[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
Yes just that Can I make the Whole sheet have the same formula ( could be 3000 cells) custom format might be the way.. <style="cheeky"> Does any one have Excel? and does it give the format for Forced Decimal? </cheeky> On Tue, 2010-08-10 at 15:54 +0100, Philip Whateley wrote: > Do you mean that you want to type in the amount in pence (13595, say) > and have it automatically formatted as pounds and pence (e.g. Â135.95)? > > If so, the easiest way might be to enter values as pence, and then > divide by 100 into another cell (or the same cell on a different sheet > e.g. sheet2.a1 =sheet1.a1/100) > > Otherwise, you might be able to write a custom format, similar to the > way formatting as percentage works by converting 0.1 to 10%? > > A macro to shift the decimal point might be possible, but I can't see an > easy way that does not involve a circular reference. > > Phil > > On Tue, 2010-08-10 at 15:12 +0100, 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 > > > > > > > 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