Hi Terry, (for the macro approach, you asked for)

In Excel 2002 and above:
Tools, AutoCorrect Options, AutoFormat As You Type (tab
[x] Internet and network paths with hyperlinks.
(Would only affect individual cells as typed)

If you reenter the value with F2 then Enter for each it will
become a hyperlink. But for a lot of cells you would use a macro...

macro approach:
Creating Hyperlinks for all Cells in a Selection (#MakeHyperlinks)
http://www.mvps.org/dmcritchie/excel...MakeHyperlinks

To install a macro that you would get from the above
http://www.mvps.org/dmcritchie/excel....htm#havemacro

More information on Hyperlinks in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"Terry Pinnell" wrote...
I have a set of standard URLs in my text editor, like
http://www.xyz.com
http://www.abc.com/123.htm
etc

I paste them into a new Excel 2000 column. But how can I quickly get
them all to become proper links, so that a click will open that
address in my browser please?