how type e-mail add. not hyperlinks in excel

I need to do a merge and it won't take my e-mail list because they have all
turned to hyperlinks...how do I type them and not have them turn into
hyperlinks?

PLease e-mail me @ [email protected]

thanks so much

Check out

http://www.mcgimpsey.com/excel/nohyperlinks2.html

and

http://www.mcgimpsey.com/excel/nohyperlinks.html

In article <[email protected]>,
"nc" <[email protected]> wrote:

> I need to do a merge and it won't take my e-mail list because they have all
> turned to hyperlinks...how do I type them and not have them turn into
> hyperlinks?

nc,

For Excel XP and on:
Tools / Autocorrect Options... / Autoformat as you type (tab) ->
uncheck "Internet and Network Paths with hyperlinks".

HTH,
Bernie
MS Excel MVP



"nc" <[email protected]> wrote in message
news:[email protected]...
>I need to do a merge and it won't take my e-mail list because they have all
> turned to hyperlinks...how do I type them and not have them turn into
> hyperlinks?
>
> PLease e-mail me @ [email protected]
>
> thanks so much

1) type apostrophe before email address '[email protected]
or
2) after hitting Enter, use CTRL+Z to undo the hyperlink
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"nc" <[email protected]> wrote in message
news:[email protected]...
>I need to do a merge and it won't take my e-mail list because they have all
> turned to hyperlinks...how do I type them and not have them turn into
> hyperlinks?
>
> PLease e-mail me @ [email protected]
>
> thanks so much