is there a good way to preceed an excel value with "0" 1

[Pack10]

I often import a spreadsheet into access which contains a field of 9 numbers.
I would like to add a "0" to the value and make it text, however when -
Import this into access, the "0" drops off. A co-worker showed me a quick and dirty using a concatenate function with the "0" and making it a text field.
We added a column then concatenated the 0 with the value in the bad column. Is there a better way? Thank you

 

[SkipVought]

Hi.

Use the TEXT function in Excel to CONVERT a number to a fixed width string of digits with leading zeros...
[tt]
=[TEXT(A2,"0000000000")
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}