Re: [libreoffice-users] Dollars & Cents in Spreadsheet

Hi ..,

jalcradus wrote (30-05-11 18:13)
> Was wondering if there's a way to get a "Dollars&  Cents" format when
> entering numbers in the spreadsheet.  In other words if you enter "1-2-3" in
> a cell, the result would be formatted to 1.23 (one dollar and twenty-three
> cents).  This is useful for accountants and others who regularly enter
> financial data involving currency.  In MS Excel there is a checkbox for this
> in the options menu.  Is there any way to get this type of format in Libre
> Office?

Simply Format>Cells
Or via the Styles window (F11) you can also define styles for 
(different) cells

HTH,
Cor

--
 - http://nl.libreoffice.org
 - giving openoffice.org its foundation :: The Document Foundation -


--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted