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
|