Common problem. I have lots of issues importing Excel spreadsheets with observations like #N/A, ot blanks in what should be numeric columns. Here's what you do: Save a copy of the excel spreadsheet as a .CSV file; Import that CSV file; Unlike with Excel, import now prints a detailed log (why only for CSV files and not Excel is a total mystery to me) which you can edit, or modify the formats and informats; Really obvious... NOT.
... View more