Cell Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
Tools > Options > Edit Uncheck "Fixed decimal"

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Use Tools | Options; open the Edit tab and deselect the "Fixed decimal" box
best wishes
 
Not formatting, I would suspect.

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