#NUM! shows up in some cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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;
 
Back
Top