Convert a number to Text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 22 May 2008 21:20 GMT

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....

Reply to this Message

John Bundy - 22 May 2008 21:43 GMT

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)

Signature

-John
Please rate when your question is answered to help us and others know what
is helpful.

> 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....

Reply to this Message

Tom - 22 May 2008 21:57 GMT

Thanx John

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

> The easiest way is to convert them in the vlookup, to lookup a number against
> text put a & "" after the lookup value like this
[quoted text clipped - 14 lines]
> >
> > Gets redundant....

Reply to this Message