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 15:12:25 +0100
kevin <kevin.lucas@xxxxxxxxxxxxxxxxxx> wrote:

Hello kevin,

> (currency)  in a cell and add the Decimal point ( to 2 places ) without
> me having to type it at all?

Format the cell as type;currency.  In the default setup there's an icon
in the toolbar for it.  You'll still have to enter the decimal point,
but not trailing zeros.

-- 
 Regards  _
         / )           "The blindingly obvious is
        / _)rad        never immediately apparent"
Going round on the Circle Line trying to find a way out
Titanic (My Over) Reaction - 999

Attachment: signature.asc
Description: PGP signature

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