convert excel import

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Excel imports cells with numbers y=that begin with "0" by
stripping all the zeroes. How do I take a set of records
and convert to numbers with a zero in front?

For example: 101 to 0101

or 789500 to 00789500, etc.

Thanks,
 
Pat,

Depends whether you want them to continue to function as numbers or
not, i.e. sort according to numerical value, do calculations or other
data manipulation. If not, you can put a new text field in the table,
and run an Update Query to convert the value of the new field to
Format([YourNumberField],"00000000")

- Steve Schapel, Microsoft Access MVP
 
Back
Top