View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default How do I force a leading zero character eg 07817

"m800afc" wrote in message
...
I am entring in order codes on a stock order sheet. The codes have 5
digits.
Some of them begin with 0 (zero). How do I force the cell to report the
correct number, ie 07817, and not 7817 as it is doing at the moment?


Format the cell as text before you enter the number.
--
David Biddulph