Hyperlinks not active

[Mr Crowley]

I have a 2007 worksheet where I have a column of about 250 hyperlinks. Non
of them show up as hyperlinks. When I move my mouse over them they dont do
anything. Is there a way I can make these cells which are valid web
addresses, a working hyperlink??


Thanks

CARD

 

[Gary''s Student]

With your "dead" hyperlinks in column A, in B1 enter:

=HYPERLINK(A1) and copy down