Numbers stored as text convert to numbers?

[Darth_Beckett]

Ok so in excel I have some numbers that are stored as text. The reason being that they are zip codes and some begin with 0 and excel doesn't want numbers to start with 0....so when I import these into an access field that has an input mask for zip codes...will it convert these correctly since the field is a text with input mask?

 

[boblarson]

If the table you import to has the field defined as text it won't change your data from the datatype it already is defined as. So, if it is defined as text in Excel, and your table's field is text, it will import as text.