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

2011-05-30 Thread plino
:) 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/Dolla

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

2011-05-30 Thread Cor Nouws
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 mor

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

2011-05-30 Thread plino
> (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.doc

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

2011-05-30 Thread Cor Nouws
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 th

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

2011-05-30 Thread plino
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 colu