Hi guys, thank you all for replying and helping. I just figured out how to convert the html data on Excel to numerical data myself....by accident I might add.
All I did was copy and paste the data to notebook and saved it as .txl, then opened it with word. Then do a copy and paste special as text back to Excel. Now all the data is in numerical format!
Try it for yourself people...its quite an easy and clean way to do it.