View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default excel 2002 cells with leading zeros

ToolsOptionsEdit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"navigator 2" <navigator wrote in message ...
|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?
|