my cell entries are automatically being displayed as a decimal?

M

Max

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
 
K

Kevin B

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).
 
E

Elisabeth

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.
 
M

Max

Thanks to all.
That did the trick... now if I can figure out how I checked the box to begin
with :)
 
Top