[libreoffice-users] Re: Dollars & Cents in Spreadsheet
:) In fact, after a quick search in Google, I found out that there is such a feature in a competing product ;) http://www.teachexcel.com/excel-help/ev.php?i=2957 Maybe this could be added as a feature request for Calc? -- View this message in context: http://nabble.documentfoundation.org/Dollars-Cents-in-Spreadsheet-tp3002443p3004072.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@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
Re: [libreoffice-users] Re: Dollars & Cents in Spreadsheet
plino wrote (31-05-11 00:09) (can even give a clumsy work around). If it's better than having calculations in another column, please do. I could use a trick that saves me from typing the dot (because I often type the dot twice and then have to go back to correct it...) Cannot find it any more. But had to do with nested formula's in the custom cell formatting, IIRC, so worked with limited range of numbers and needs non-proportional font too :-) As I wrote: clumsy :-) Cor -- - http://nl.libreoffice.org - giving openoffice.org its foundation :: The Document Foundation - -- Unsubscribe instructions: E-mail to users+h...@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
[libreoffice-users] Re: Dollars & Cents in Spreadsheet
> (can even give a clumsy work around). > If it's better than having calculations in another column, please do. I could use a trick that saves me from typing the dot (because I often type the dot twice and then have to go back to correct it...) -- View this message in context: http://nabble.documentfoundation.org/Dollars-Cents-in-Spreadsheet-tp3002443p3003716.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@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
Re: [libreoffice-users] Re: Dollars & Cents in Spreadsheet
Hi Plino, plino wrote (30-05-11 23:49) 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 Yes I know the accountancy notation pretty well (can even give a clumsy work around). But in the original post I read: " the result would be formatted to 1.23 (one dollar and twenty-three cents). " So I did not conclude that the question was about accountancy notation. Greetings, Cor -- - http://nl.libreoffice.org - giving openoffice.org its foundation :: The Document Foundation - -- Unsubscribe instructions: E-mail to users+h...@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
[libreoffice-users] Re: Dollars & Cents in Spreadsheet
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 users+h...@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