Mike, when you paste the hyperlinks into Excel, choose the paste values
option instead of the regular paste. (If you're using the Paste icon in the
Excel toolbar, click on the little arrow to the right of it and select the
"Values" option; or right-click, choose "Paste Special..." then choose the
Values option).

"Mike Nolan" wrote:

i just made a post concerning the problem of cutting and pasting e-mail
addresses into excel. they always come out as hyperlinks and it's driving me
crazy. i was told to do the following and it does not work. possibly i am
going to be forced to type every e-mail address in and if i do that it
doesn't happen.

Click ToolsAutoCorrect Options... then click the "AutoFormat As You Type"
tab, and uncheck "Internet and network paths with hyperlinks"

please e-mail me at:

thank you.