Thread: numbers problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default numbers problem

Pull-down:

Tools Options... General and clear Fixed decimal
--
Gary's Student


"markvr6" wrote:

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