View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default How do I begin value with the number zero?

Maybe Format|Cells|Custom, then try '000' (without quotes) for 3 digit
numbers


"sportsandspeed" wrote in message
...
Dumb question, but how do I begin a cell value with the number zero? I've
tried changing the cell format to text and that didn't work. I also tried
putting a ' in fornt and that worked until I closed the file and reopened
it.
After reopening, the zero was missing again. By the way, I'm using Excell
2003.