Auto fill in missing digits

  • Thread starter Thread starter txlogic
  • Start date Start date
T

txlogic

I have a file I am importing into a table and if the number begins with one
or two 0's they are missing from the data in the new table. How can i set up
the formatt on the table so the numbers are a set length and if not, it will
automatically fill in the missing 0's?
 
I have a file I am importing into a table and if the number begins with one
or two 0's they are missing from the data in the new table.  How can i set up
the formatt on the table so the numbers are a set length and if not, it will
automatically fill in the missing 0's?
Click to expand...

What is the data type of this field? If it's numeric, then you can't
keep the leading zeros. If it's not a field that you do math on, it
should probably be a text field anyway.

You can use Format$() to do this.
 
I have a file I am importing into a table and if the number begins with one
or two 0's they are missing from the data in the new table. How can i set up
the formatt on the table so the numbers are a set length and if not, it will
automatically fill in the missing 0's?
Click to expand...

Use a Text field, not any sort of number. As numbers, 31 and 031 and
0000000000031 are just three different ways of depicting *exactly the same
number*.
 
Back
Top