change @ to & while linking excel to access

T

tbarse98

I have linked an excel spreadsheet to our access database. I have text
columns that access automatically formats the text box to the "@" type (needs
a text character). Some of the rows have numbers only so it returns the
dreaded num# error. I want to avoid having to add a space to all the cells
with numbers only. Any help would be greatly appreciated.
 
Top