Dividing by 100?

[cecil23]

Using Excel 2000 at work, I find that every number I enter on th
spreadsheet is divided by 100. If I enter 1, Excel displays it a
0.01, and treats it that way. Obviously, this is not a format issue.


I've worked with Excel for years, and never had this happen. I mus
have touched something (under Tools-Options?), but I cannot figure ou
what. Any ideas? (I have the suspicion this is one of those "Doh!
problems that has an amazingly simple answer)

 

[Peo Sjoblom]

Tools>options>edit and uncheck fixed decimal places..

 

[Frank Kabel]

Hi
goto 'Tools - Options - View' and uncheck 'fixed decimals'

 

[cecil23]

Thanks much....