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


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:


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

Hope this helps,