entering 1.0 displayes as 0.1?

[Guest]

When I enter 1.0 it is displayed in the cell as 0.1. If I enter 123 it is
displayed as 1.23. I know it is something simple but just can't find the
answer

 

[Chip Pearson]

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


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

 

[Guest]

Thanks for the prompt reply. I new it was simple.