Format column to text

Hi Guys,

I was converting a column to text values with this:

Please Login or Register  to view this content.

However it does line it to the left as text but in a vlookup it still acts as a number.
So without the " " around it.

How can I convert the column to real text format?
Thanks.

Hi rpinxt,

try this:

Please Login or Register  to view this content.

Thanks works like a charm berlan!
Bit more code then the one line, but if it works thats no big deal

Well MarvinP I have 2 data sources and in 1 source the number to be lookedup are in number format and in the other in text format.
Easiest fix would be to convert the number source to a text source in order for the vlookup to work.
Thanks for the link...I will study them

Thanks for the Rep rpinxt. Here's a version taking into account if no number values would exist within column 5.

Please Login or Register  to view this content.

All best

thanks berlan!

You're welcome