Leading Zeros

  • Thread starter Adding Leading Zeros
  • Start date
A

Adding Leading Zeros

I have a list of numbers in a table column:
456
12
4568
111111
What I need is to have the numbers all 9 digits like:
000000456
000000012
000004568
000111111
I just don't remember how I updated the field in one step. I know someone
must have the answer.
Thanks.
 
T

tina

if you just want to "show" 9 digits, format the field as 000000000.
if you want to "change" the values to include the leading digits, the field
must be a text field, not numeric. to update all the values in a text field
at once, try an Update query on a *copy* of your table, using the following

Right("000000000" & [TableName].[FieldName], 9)

hth
 
Top