Convert a number to Text

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a column of numbers and text that I am trying to use in a vlookup
formula. Rather than go thru the numbers and add a ' at the front to format
as text, is there a simple fix that I can employ to change these 500 or so
numbers.....

Gets redundant....
 
The easiest way is to convert them in the vlookup, to lookup a number against
text put a & "" after the lookup value like this
=VLOOKUP(A1&"",C1:J36,1,0)

if zeroes in front are messing you up then you can convert them to text with
=Text(A1,"0000")

And i think i confused myself about which one you are looking up against
which, so this formula looks up text against a list of numbers

=VLOOKUP(--A1,C1:J36,1,0)
 
Thanx John

I also found a work around using the text to columns feature on only the
"Numbers".
 
Back
Top