numbers will not display as entered unless 'text' format is chosen

[gavin]

Hello,
I have had a look both here and in the documentation, and I cannot see
what may have changed between Office vX and Office 2004 with regard to
number formatting in cells.
Basically, I 'used' to be able to enter a number in a cell with a format
of general and it would display it exactly as entered. However now unless
I enter a decimal point in the number followed by one or two zeros the
number will either display as 0.02 or 0 (say I have entered 2). Only when
I change the format of the cell to text will this now display correctly.
What sort ot weird-o changes have happened in Excel in 2004 for this
behaviour to occur, and can anyone tell me hwo to permanently revert the
application back to its previous behaviour!
Thanks in Advance
Gavin

 

[Michael R Middleton]

Gavin -

Maybe, uncheck

Excel | Preferences | Edit | Fixed decimal places

- Mike www.mikemiddleton.com

+++++++++++++++++++++

Hello,
I have had a look both here and in the documentation, and I cannot see
what may have changed between Office vX and Office 2004 with regard to
number formatting in cells.
Basically, I 'used' to be able to enter a number in a cell with a format
of general and it would display it exactly as entered. However now unless
I enter a decimal point in the number followed by one or two zeros the
number will either display as 0.02 or 0 (say I have entered 2). Only when
I change the format of the cell to text will this now display correctly.
What sort ot weird-o changes have happened in Excel in 2004 for this
behaviour to occur, and can anyone tell me hwo to permanently revert the
application back to its previous behaviour!
Thanks in Advance
Gavin