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.
 

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

Number Format 2
Adding a IF Statement within a Select Query. 2
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
The word "zero" appeared in a cell. 2
Greater Than Symbols and calculations 0
How can I keep a zero (0) at the front of a set of numbers. 2
trying to store non-zero numbers from a list into sequential cells 1
Blank result cell instead of zero 1

Top