Cor Nouws wrote: > > Simply Format>Cells > Or via the Styles window (F11) you can also define styles for > (different) cells >
That wouldn't work, Cor ;) It's not a question of formatting. The OP wants to type 123 and for the cell to display $1.23 The only solution I can see is to have a column where you type the values with no point (e.g. 123, 300, 98) and have it divided by 100 in another column and formatted as currency. These calculated values can even be on a separate worksheet so that you have one column for quick data entry and another worksheet where all is presented neatly :) -- View this message in context: http://nabble.documentfoundation.org/Dollars-Cents-in-Spreadsheet-tp3002443p3003620.html Sent from the Users mailing list archive at Nabble.com. -- 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
