Formatting does not change the underlying values

Try this to convert the text numbers in the lookup col to real numbers

Copy an empty cell, then select and right-click on the lookup col, choose
Paste special check "Add" ok

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Confused" wrote in message
...
I am using vlookup to lookup values in data copied from a CSV file. It
first
returned #N/A so i changed the Number Format (of the Lookup_Value) to
"Text"
and it still returned #N/A but when i pressed F2 and then enter (on the
Lookup_Value cell), the vlookup returned the correct value.

This is really driving me up the wall, can anyone help?