View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default typed numbers entered in cell wrong

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


"Fred J" <Fred wrote in message
...
I typea number in a cell and it appears divided by 10 i.e type
90 enter amd
.9 appears in cell