Cell format has suddenly changed in all new spread sheets

A

Andy

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
 
G

Gord Dibben

Andy

Tools>Options>Edit.

Uncheck the option at "Fixed Decimal Places"


Gord Dibben MS Excel MVP
 
S

SteveW

Just asking...
Did you see my reply
I ask because I want to check that my new server is propagating correctly.
It's not the first time that I've seen posts several hours after mine that
have *exactly* the same answer
hate to think my posts get through and are missed :)

Steve
 
A

Andy

Hi steve,

Yes thanks,

I was out and off line for about 18 hours. Many thanks for the tip! I do
still have another problem which I'll post later once typed.

Thanks Steve.
 
A

Andy

Many thanks for your reply!
--
Ian D Anderson


Gord Dibben said:
Andy

Tools>Options>Edit.

Uncheck the option at "Fixed Decimal Places"


Gord Dibben MS Excel MVP
Click to expand...
 
Top