View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Elisabeth Elisabeth is offline
external usenet poster
 
Posts: 32
Default my cell entries are automatically being displayed as a decimal?

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


"Max" wrote:

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