Linked XLS worksheet

[TimE]

Column A in Spreadsheet is AlphaNumeric and Numeric. When I link to the worksheet, it displays the Alphanumeric entries but shows #Num! for the numeric entries. I have tried changing the format of the cells from number, general and text but get the same results. How can I show both alphanumeric and numeric in a table?

EXAMPLE:
DC100900
AA999111
11199922


Thank you in advance for any assistance!

 

[ghudson]

You can not mix formats in the same field. You will need to format the Excel data source in the column and the Access field in the table to TEXT.

 

[TimE]

Thank you for your reply ghudson.

Because it is a linked table (to the spreadsheet), I can not change the table properties to text. When I view it, it does show to be text already. The column in the spreadsheet is formatted to text also but I get the same results.