Thread: My excel spread sheets are dividing all numbers input by 100.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default My excel spread sheets are dividing all numbers input by 100.
ToolsOptionsEdit.

Uncheck "fixed decimal places".


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 20:14:01 -0700, Prospector
wrote:

There are no formula apparent and this occurs on all new worksheets and even
after reloading the software. The number 3 input appears as 0.03 and so on.

Reply With QuoteReply With Quote