Thread: numbers problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default numbers problem

Hi Mark

Somehow fixed decimal places has got set.
Go to ToolsOptionsEdit and uncheck Fixed Decimal places.

--
Regards

Roger Govier


"markvr6" wrote in message
...
I have a spreed sheet which I have been using for 12 months,
now everytime I type in a digit and hit enter the single digit is
displayed
as decimal. ie 7 end as 0.0007