D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] OO Spreadsheet decimal

 

On Tue, 10 Aug 2010, 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?

Right-click on the cell (or column or row) and select Format Cells..

There are many options, but you might want the one that looks like 1234.12

Gordon

--
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq