Have data that is a mix of number and text.
Ex: the field if PN
The data could be:
ABC123
123
AB23

I have formatted the column as TEXT, but if I use function isnumber(a2) for
value 123, it comes back TRUE.

I want 123 to be considered text; I'll be importing into Access.
What's my next step?

--
Eva H. Linich
Business Applications