I received an excel spread sheet that I am linking to Access. Everything
looks fine in the Excel spreadsheet but when I look at it in Access I get
#NUM! in some cells. They are the Zipcode, phone and fax fields. I think
that the fields have mixed data in them, some numeric and some non-numeric.
How do I get the data in the cells to be all the same data type? I have
tried formating a cell to text and copying the data into it, but that does
not work. I tried to customize the cell but I can't get that to work either.