Problems with data format? My code goes wrong?

I am a new beginnner to excel VBA. I hope to automate the task of importing data from web into excel. However, when I run the following code, the result is far from what it should be :

Please Login or Register  to view this content.

The result of the above code is shown below and is wrong :

wrong.png

Obviously, there is no formating? I have to load the data into the sheet mannually and the expected result should be :


right.png


How can I automate both task (import data and load it into the sheet) with VBA? Which part of the code goes wrong? Please give me a hand!

Hello terrryc2115,

Thank you for you quick response in correcting the matter