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 [email protected]
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
