Thread: The number I type in a cell, e.g. 500, appears at 0.5 - why?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default The number I type in a cell, e.g. 500, appears at 0.5 - why?
"Becky" wrote in message
...
If I type, for exampe, 500 into an excel cell it appear as 0.5 when I
press
enter. How do I stop this from happening?

Tools/ Options/ Edit
Make sure "Fixed decimal places" is unchecked.
--
David Biddulph


Reply With QuoteReply With Quote