Hi,

Im linking my summary sheet to a pivot table using product codes. Because
the users have entered codes incorrectly, i keep getting n/a's where there is
obviously data in the pivot but isnt getting pulled through. This error
seems to disappear if i put an apostrophe at the start and if i retype the
whole code into the cell.

Is there a quick way of going through the errored ones and putting in the
apostrophe/retyping the code and ensuring this works?

Thanks!