I have a list of item numbers that are sent to me from different sources -
sometimes formatted as number and sometimes formatted as text. The master
file I keep for lookup formaula has the items stored as text - with my
problem being the VLOOKUP formula expecting the values to match, and is not
giving results all the time.

To cure the issue I can go to the numeric value and type a single quote
inthe cell preceding the number and this converts it to text and the lookups
work, but sometimes the list is hundreds of items long, so I am looking for
an easier way to do this. Simply highligting the column and formatting all
values as text does not do the trick - is there a formula that will work that
I can apply to the cells? So far I have not had luck with the TEXt and T
formulas.

Thanks