Convert colum of web addresss so they are clickable for hyperlink to web.

I have 4,000 rows of web addresses in text format and I want them all to become clickable to go to their respective web address

format is: www.company.com

How can I best accomplish this on a mac with excel 2008?

thanks, it appears to look like a link when I do that but when I click on it i get a message that says "can't open the specified file" instead of opening web page.

i need to add http:// in front of source entry... thanks

1) make sure you have http:// in front of www. replace www with http://www for all
2) use hyperlink function to copy info from desired cell =hyperlink(a1)
3 copy that cell and paste down
4) copy all cells and paste special using values only

Thanks again Fdibbins

Solved