Basically i want to create a HTML link in Excel but i dont know the correct code to do so. I just type in the web address like normal in a colum in Excel and when i convert it over into an html page it just shows the actuall address of the link i typed.

For example:

I type in

http://www.abc123456789.com

The link shows up but it is not clickable its only normal text. I want it to come up as clickable.