How do I force a leading zero character eg 07817
Just enter the numbers preceeded by an apostrophe (single quote)
--
Gary''s Student
"m800afc" wrote:
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?
Thanks
Tony
|