#NUM! shows up in some cells

[Sandy]

When I link an excel SS to my table some of the numeric cells come in as
#NUM! it doesn't happen to all cells in the columns just some. I have
compared formatting and there is nothing different. Any ideas

 

[Jerry Whittle]

In that case the data is being interpeted as text instead of a number. You
might want to first import the data into another table where the problem
fields are set to text. Then run a query to see if any of the data can't be
turned into a number.

Something like this query will show which records have data that can't be a
number.

SELECT Asa2.*, IsNumeric([NumberField]) AS ZeroMeansNo
FROM Asa2
WHERE IsNumeric([NumberField])=0;