Excel divides all user input numbers by 100

[yeldarb]

When I open a new worksheet and add numeric data, or try to add numeric data to my existing worksheets, Excel divides all my numbers by 100 (e.g. enter "1" into a cell and it displays "0.01&quot. I need to enter "100" in order to get "1" to appear. THIS DOES NOT APPEAR TO BE A CELL FORMAT ISSUE. I suspect that I may have picked up a virus of some kind but after scanning my PC using Housecall it found nothing. Has anyone experienced this problem and found a fix?

 

[JVFriederick]

Tools Options Edit Fixed Decimal is probably set to 2.
Set it to 0 and no worries.

 

[yeldarb]

Thanks, but I wish it were this simple! Unfortunately this did not fix the problem (my fixed decimal was already set to zero - that was the 2nd thing I checked after the cell formatting...).