Zeros Not Showing
Custom format as 00000
or format as text before you type in the number,
or precede the number with an apostrophe.
The latter two options will leave you with text, rather than a number, so
further calculations may well be affected.
--
David Biddulph
"jkjmwilliams" wrote in message
...
How do I force numbers beginning with a zero to show? EX: 05678
|