my cell entries are automatically being displayed as a decimal?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

For some reason all my numerical entries are being entered as a decimal.
Example: I enter 65 in a cell and it changes to .065

This happens regardless of whether the spreadsheet is new or existing.

Anybody know of a fix?

Regards
Max
 
Click TOOLS/OPTIONS and click the EDIT tab. Verify that the Fixed Decimals
checkbox has not been checked on. This automatically punctuates numeric
entries with the number of stated decimal positions (default of 2).
 
Sounds like the Fixed Decimal places option is selected. To deselect it, go to

Tools >> Options
Select the Edit tab and uncheck the Fixed Decimal box if it is checked.
 
Thanks to all.
That did the trick... now if I can figure out how I checked the box to begin
with :)
 
Back
Top