I know how to change formats - however I have a formatted cell for a 100 +
rows that appear to have an apostrophy as a lead. While I don't see it, I am
concluding that because changing formats to general or text is not removing
the green box in corner and is not allowing me to do a vlookup using this
column of info.