Thank you but I tried that & it doesn't work. But further down in the
discussions I found a macro that solved the problem.
--
Slan.


"yzhang00`" wrote:

you can try, Tools - AutoCorrect Options - Autoformat as you type - click
"Internet and network paths in hyperlinks"

"Liam" wrote:

i imported a contact list from outlook to excel 2003 but the email addresses
are only text - any way to format an entire column instead of one by one?
--
Slan.