Copy & Paste Data from Web into Excel

[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

 

[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