Hi all,

I have a large list of numbers in column A, about 60k. Scattered throughout
that list are numbers that Excel read as formulas since the fields were not
converted to text ahead of time. I can have this list of numbers recreated
again and this time in the correct format so that I should not have this
problem again. What I need to do though is identify which of the numbers
have been "fixed". Is there a way to take my new list and put it next to the
old one and then run some kind of compare function that will allow me to
isolate the data that has been fixed? I believe there are at least 1000 so
I'd prefer not to do it manually.

Thanks in advance for any guidance.