Preceding zeros

G

Guest

how do I keep preceding zeros in a field, i.e. an autonumber field. I want
my numbers to start at 001, but I want the preceding zeros to show.
 
D

Douglas J. Steele

Numbers don't have preceding zeros when stored: that's formatting, which
really has nothing to do with the value. If you want 3 digits, set the
format for the field to 000
 
G

Guest

Douglas, thank you SO much for your help!!

Douglas J. Steele said:
Numbers don't have preceding zeros when stored: that's formatting, which
really has nothing to do with the value. If you want 3 digits, set the
format for the field to 000
Click to expand...
 

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

Preceding Zeros with Concatenation 4
Number Format dropping preceding zero on 1 User's form 1
Dropping Zeros 8
sequentially numbered text field - not autonumber 2
Preceding Zero's 2
How to open CSV as text? 4
remove preceding zeros 2
Turning off auto formatting 3

Top