Thread
:
excel 2002 cells with leading zeros
View Single Post
#
2
Posted to microsoft.public.excel.misc
Niek Otten
external usenet poster
Posts: 3,440
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?
|
Reply With Quote
Niek Otten
View Public Profile
Find all posts by Niek Otten