[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
I've found the same thing in Excel it's 0.00_ ;[Red](-0.00) which gives Type in 1234 and get 12.34 Wonderful! :) On Tue, 2010-08-10 at 16:36 +0100, Henry Bremridge wrote: > On Tue, Aug 10, 2010 at 04:13:40PM +0100, tom wrote: > > On 10/08/10 15:12, kevin wrote: > > >Hi all > > >is there a oo Spreadsheet guru around? > > >I would love to know if you can get Spreadsheet to accept a number > > >(currency) in a cell and add the Decimal point ( to 2 places ) without > > >me having to type it at all? > > > > > >I think in Excel this is possible but cannot find it in OO > > > > > >if not OO the is is possible in javascript as I can do this in a web > > >form > > > > > >Its VAT return time and I have to break down each line on the invoices > > >to one of 12 groups > > >Thanks in advance > > > > > > > > >Regards > > > > > >Kevin Lucas > > >Minions Post Master(Sub) > > >Ten Years in the Making! > > >www.minionsbandb.co.uk > > >www.tearooms.minionsbandb.co.uk > > >Po House, Minions, > > >Liskeard Cornwall > > >PL14 5LE > > >01579363386 > > > > > > > > In OO you can set the cell format to a currenc( Ânnnnn.xx) and it > > will put the  in but you have to put the . in to tell it the > > pennies > > In JS you could use a form <input type=text > > onchange=formatfunction(this)>.... > > > > Now if we had a decent open standard simple business xml data > > exchange format there would probably be a simple to do this.... > > > One of nicest things about oOo, particularly when entering data into > spreadsheets is the F11 key. > > - Press F11 > - Select a cell or a range of cells and double click the entry in the > styles and formatting dialogue: cells formatted > - Change the formatting instructions (select a style, right click and > modify) and all cells with that formatting are changed > - If you create your own format instructions then you can attach that to a > key stroke combination (Tools | Customize) and then save that as a > default spreadsheet template (File | Template | save). For example on my > spreadsheet if I press CTRL-N then then cell is formatted to > - ,000 > - 2 decimal places > - negative in red in brackets > > Similarly if I am working in multiple currencies then I tend to create > formats for eg INR, USD and EUR and use the F11 key to format accordingly. > > YMMV but it saves me considerable time: and irritates me when I use excel > > Anyway one way to solve your problem: > - Set the format instructions to percentages > - Enter the data as a percentage > - Once all entries done, Change the format instructions on F11 to the > appropriate currency > > Regards Kevin Lucas Minions Post Master(Sub) Ten Years in the Making! www.minionsbandb.co.uk www.tearooms.minionsbandb.co.uk Po House, Minions, Liskeard Cornwall PL14 5LE 01579363386 -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq