Link Excel table - found #num!

G

Guest

Hi, I have data in excel e.g.

59
45
67
-
78
90

actually this is my students marks. simbol - show they absent for the paper.
I link the table. but at access it show

59
45
67
#num!
78
90

Q: any way to display both type of data?
or any way to hide #num! when print at report?

TQ
Param
 
G

G. Vaught

Excel treats the values as numbers. When you enter a value that will be
construed as text, Access will indicate there is an error. Replace the -
with 0 and it should remove the error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#NUM! Error in linked table (excel) 1
#Num! Error in Link to Excel 1
Linear Regression 1
#Num Error Linked Excel Table 1
how to link to a csv file with a date field in it? 3
linking to excel table - problems with data type 2
Linking to Excel, getting #Num! 14
Pivot Table Data Column Sort Excel 2007 1

Top