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

  • Thread starter Thread starter Judy
  • Start date Start date
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?
 
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.
 
Back
Top