It might be possible to avoid even needing a macro: have
you tried adding another column to the left and using the
TEXT function to force the value to be seen as text; in
other words something like:

A1 = TEXT(B1,"#######")
etc...

Don't know if this would work but could be an easy fix.

-----Original Message-----
I have a VERY large table that I want to use in a VLOOKUP
function. The
first column of the table, if I understand correctly,
needs to be in
text format. It is currently all in number format,
causing my VLOOKUP
function to not work properly. If I right click on the
entire column,
and format it into TEXT format, the numbers all align
over to the left,
appearing to have been converted to text. However, the
VLOOKUP
function still doesn't work. BUT....if I find the value
in the table
manually, F2 it, and then hit ENTER, my VLOOKUP function
then DOES
work.

It almost seems to be that it doesn't actually convert to
text unless I
do this step (F2, enter). The problem is, there's over
40000 rows in
this table, so I can't possibly do this to every cell in
that first
column. Is there a macro (I'm macro-challenged) or some
other way that
I can do this quickly and easily?


---
Message posted from http://www.ExcelForum.com/

.