I read a lot of posts on this topic but most are having a problem reading from Excel. I’m successfully reading a list of columns that contain numeric record IDs into a Generic Variable. I need to look for the rows that have “#N/A” in the cell. The "#NA’ is coming in as a number. I tried format changes to the Excel sheet from General to Text as well as trying several ToString conversions and all I get is -2146826246 as a string value. How do ready the “#NA” into a string variable.
Excel column G:
MatchIssue = -2146826246 for Row 6
Thanks ! Scott