I know that the Subject might be a little off, but here's my issue.

I am importing data from a spreadsheet into an Access database. In
this particular column of data, the data looks like this: 911B00,
91FT20, 911000, 91E000.

My issue is that when I import that column if data, for some reason it
takes the records with a "E" (like 911E00) and displays them as
exponential numbers and displays "9.10E+01" - how can I prevent Access
from doing that - or what function can a put in a query to fix that?