I have inserted some rows into a Calc spreadsheet in which I have used a
variety of number formats including "Number" and "Currency".
If I type "1" into one of the new blank cells, it shows up as $1
If I go to Format>Cells>Number I find that "Number is already selected
My workaround is to go to Format>Cells>Number and change the number format
to "Currency". When I come out I now have $1.00. I then go back into
Format>Cells>Number and change the number format to "Number", and when I
come out I have "1", which is what I want.
Any idea why this is happening?
Many thanks, James
PS using OOo 3.1.0 running under Windows XP
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
