convert excel import

[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,

 

[Steve Schapel]

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