Copy & Paste Data from Web into Excel

K

Kelvin Pakaree

When I do the above & use Vlookup for numerical data the
numeric data is not recognised, although some data are in
another excel workbook. How can I sort the data from the
web so that I can do a proper vlookup
 
B

Bernard Liengme

What looks like a numeric field is actually text.
This trick often works:
In an empty cell enter the value 1 and copy it
Select the offending numbers and use Edit/Paste Special->multiply
Delete the cell with the 1

Best wishes
 
Top