Excel 2002

I am populating an excel spreadsheet with one column (‘ooo’s of rows) which contains a URL in the format “http:/xxxxxxxx.com” (including the “)-by importing data from a txt file.

How can I quickly change all the rows into a hyperlink. I currently do it by double clicking each cell, row by row, and it becomes a hyperlink, but it takes hours!

help someone