Thread: Cell format has suddenly changed in all new spread sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy Andy is offline
external usenet poster
  
Posts: 414
Default Cell format has suddenly changed in all new spread sheets
When I used to entre a number in my spread sheets as 120 it would read 120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now 1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please
--
Ian D Anderson
Reply With QuoteReply With Quote