I linked Excel table and am having an issue with one of the field format
conversion as follows:

The field in question is an alpha numeric ID field/column in Excel with some
all number, all text and combined number and text cells formatted as General
i.e MLE, 4523, S8T1 etc...When you open the linked spreadsheet in a direct
linked table this field shows records with the error #NUM! possibly because
during the field conversion Access assumes that it's a number field dropping
the all text. I tried converting the entire column to text in Excel and now
it gives me an error on the all number fields.

MLE
#NUM!
SSM
#NUM!

I don't see any other format in Excel that would accomodate this
circumstance. Please help...thank you.