how type e-mail add. not hyperlinks in excel

[nc]

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

 

[JE McGimpsey]

Check out

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

and

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

 

[Bernie Deitrick]

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

 

[Bernard Liengme]

1) type apostrophe before email address '[email protected]
or
2) after hitting Enter, use CTRL+Z to undo the hyperlink
best wishes