Format column to text

Hi Guys,

I was converting a column to text values with this:

Sheet1.Columns(5).NumberFormat = "@"

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.