Cell Formatting

S

Steve

Seem to have created a monster. When I type 122 in a cell it displays as 1.22
Any numeric I type ends up with decimal point moved two places to the left
and I can't seem to correct. Is there some obvious formatting that I am
missing?
 
C

Chip Pearson

On the Tools menu, choose Options then the Edit tab. There, uncheck the
"Fixed Decimal" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
S

Sandy Mann

Tools > Options > Edit Uncheck "Fixed decimal"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
B

Bernard Liengme

Use Tools | Options; open the Edit tab and deselect the "Fixed decimal" box
best wishes
 
S

Steve

Thanks, I've been looking everywhere and guess I missed this one. Again
thanks and Best
 
D

David Biddulph

Not formatting, I would suspect.

Tools/ Options/ Edit:
Unselect "Fixed decimal places".
 
Top