Thread: Cell format has suddenly changed in all new spread sheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Cell format has suddenly changed in all new spread sheets
Andy

ToolsOptionsEdit.

Uncheck the option at "Fixed Decimal Places"


Gord Dibben MS Excel MVP

On Sat, 28 Oct 2006 01:17:02 -0700, Andy wrote:

When I used to entre a number in my spread sheets as 120 it would read 120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now 1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please

Reply With QuoteReply With Quote