When 1 inserted in cell 0.01 displayed

L

Louise C

Hi There,

Looking for a little help! When ever I insert 1 into a
worksheet 0.01 is displayed and I have no idea why. Any
ideas?

Thanks in advance

Louise
 
C

Chip Pearson

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top