Convertig Number to Text - equivelent to single quote
 

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

Convertig Number to Text - equivelent to single quote
 

Copy a blank cell, then highlight your data, right click Paste Special,
select Add then click OK

----------------
mama no teeth

"Nathan" wrote:

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