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.

Format a blank cell to General or Text (I'm assuming Access will have no
problem importing eithr format), enter 1, copy the cell, select the cells
that you want to be of the same format, click Copy Paste Special, under
Paste select All, under Operation click on Multiply. This will change the
format of your cells to the same format as the cell in which you entered 1
(General or Text).

"camell" wrote:

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.

This changed the values of the numeric items.

"camell" wrote:

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.