Re: [users] one thing i can't figure out

2009-09-24 Thread James R. Liebert
See http://qa.openoffice.org/issues/show_bug.cgi?id=30470, OO Issue 30470. This formatting device is called Fixed Decimal in Excel. It remains absent from OO Calc, as you will read. JRL Akron Stanton A Hershman wrote: in excel you can adjust the cell contents so that if you enter -5432 you

Re: [users] one thing i can't figure out

2009-09-24 Thread Stanton A Hershman
On Wed, 23 Sep 2009 17:32:15 -0400, you wrote: thanks There is a switch in Excel relevant to currency cell formats that mimics many adding machines, automatically making the last two digits entered the decimal places. Find it in OO. The downside is you must enter 00 for even dollars. For me

[users] one thing i can't figure out

2009-09-23 Thread Stanton A Hershman
in excel you can adjust the cell contents so that if you enter -5432 you end up with (54.32) in red as the final cell contents in Oo i try that after adjusting the cell contents and i end up with (5432.00) in red am i missing something very simple Stanton

Re: [users] one thing i can't figure out

2009-09-23 Thread James R. Liebert
There is a switch in Excel relevant to currency cell formats that mimics many adding machines, automatically making the last two digits entered the decimal places. Find it in OO. The downside is you must enter 00 for even dollars. For me entering the decimal point with right ring finger is more