Quote:
Originally Posted by Bill Douglas
Nope 
When I enter in the number 45 it is 0.45 on the spreadsheet. |
Application preferences.
It's an application wide setting, not entry based like the Format option.
There is a general setting there.
I was just able to replicate your problem.
It will not change a current entry, only entries that occur after the preference is changed.
In my version of excell it's "Display this number of decimal places".