Thread: entering 1.0 displayes as 0.1?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default entering 1.0 displayes as 0.1?
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

Reply With QuoteReply With Quote