How do I stop Excel from changing simple numbers to their 1/100th.
 

I'm working with the latest service pack of Excel 2000.
Every number I enter into any blank cell becomes that number's 100th decimal
value. For example, typing "2" in a cell results in "0.02" when I leave the
cell.
This did not used to happen, but I don't know what I did to make it happen,
nor what to do to stop it from happening.
CC

hi
goto 'Tools - Options - Edit' and uncheck 'Fixed decimals'

--
Regards
Frank Kabel
Frankfurt, Germany

Chris C wrote:
I'm working with the latest service pack of Excel 2000.
Every number I enter into any blank cell becomes that number's 100th
decimal value. For example, typing "2" in a cell results in "0.02"
when I leave the cell.
This did not used to happen, but I don't know what I did to make it
happen, nor what to do to stop it from happening.
CC