Try using the HYPERLINK function
=HYPERLINK(A1,A1)
--
Kevin


"SteveC" wrote:

Hi, I just downloaded a bunch of hyperlinks into excel. if I highlight the
cell and put the cursor to the right of the text and press return, hte text
converts into a hyperlink. How do I do this for an entire column? Thanks
very much. SteveC

Hey thanks. Also, just found this from a MS website

Sub HyperAdd()
'
' Converts each text hyperlink selected into a working hyperlink
'
For Each xCell In Selection
ActiveSheet.Hyperlinks.Add Anchor:=xCell, Address:=xCell.Formula
Next xCell
'
'
End Sub

"AFSSkier" wrote:

Try using the HYPERLINK function
=HYPERLINK(A1,A1)
--
Kevin


"SteveC" wrote:

Hi, I just downloaded a bunch of hyperlinks into excel. if I highlight the
cell and put the cursor to the right of the text and press return, hte text
converts into a hyperlink. How do I do this for an entire column? Thanks
very much. SteveC