Rich Stanek Wrote:
When I have ran into this in the past it is normally because the field
you
are typing you vlookup into is formatted as text. Try writting a
simple
formula in its place like =1+1. If it still displays the argument then
this
is your problem.

Fix. Change the formatting to general, then retype the 1+1, if you get
the
"2", then you are good to go, and then can rewrite your vlookup
formula.

Hope this helps


An easier way is to use the text to columns tool.

Highlight the whole column then select the tool and the press finish.
That way the whole column will be done.


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=568361