MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Getting excel to recognise html text as numbers


Posted by Matthew Robinson on December 18, 2001 8:50 AM

I am trying to paste in the numbers from the following website

(http://www.photius.com/wfb1999/rankings/gdp_per_capita_1.html)

into excel so that I can manipulate them. However none of the functions will recognise the data as numbers, even when I delete the dollar sign and format the cell as a number. Any suggestions?


Posted by Russell Hauf on December 18, 2001 9:41 AM

They come in as numbers for me (formatted as currency), but try this:

=INT(Cell)

Where Cell is one of your cells with a number in it.

Hope this helps,

Russell