Thanks for the prompt reply. I new it was simple.
"Chip Pearson" wrote:
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)
"Liglagsdad" wrote in message
...
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