Hello folks,
I have a problem that's driving me up the wall and was hoping someone on here would be able to provide me with a quick fix.
When I type a number into a cell, and hit return the number comes up as a decimal. For example, if I type 25, the number is displayed as 0.25. Or if I type 1254, the number is displayed as 12.54. or 10987 is displayed as 109.87, etc.
It seems that I have changed a default setting (or some such) to display the number as 1/100th of its original value!!! I have tried playing with the formatting, but to no avail.
Any help on this would be greatly appreciated.
Bookmarks