View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
navigator 2 navigator 2 is offline
external usenet poster
 
Posts: 1
Default excel 2002 cells with leading zeros

I have suddenly found that entering numbers into an exsiting spread or a new
spread sheet in a new book that the number always has 0.00 in front of the
number I typed. Every thing else then works with small number
If I use =and then the number the problem is over come
What I do not know is if I send the work book too other users do they get
the same problem
Any ideas please?