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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
LEADING ZEROS 7
My cell is formatted to General and I keep losing the number zero 3
Show zero and not error when division by zero 5
Default number format in Excel 1
leading zeros 3
Number Formatting 4
How to count the maximum number flanked by zeros 9

Back
Top