how do I format a cell using zero as the first number?

J

Judy

I am entering numbers in an excel spread sheet and some of my numbers
startwith a zero, which does not show up. How can I change that?
 
J

Jerry Whittle

Well this is an Access database forum; however, since Access has the same
behavior, I'll take a stab:

Numbers don't have leading zeros.

If you need to see leading zeros, format it as a text field.

In Access there are some fancy ways to display leading zeros in front of
numerical characters, but then it's no longer a number.
 
Top