Preceding zeros

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