How can I stop Excel from creating an e-mail link for addresses?

[Guest]

I am creating a spreadsheet that includes e-mail addresses. When I enter the
e-mail address into the cell, it automatically creates a link that I can
click on to send an e-mail. I would like to just have the e-mail address
entered as text, but when I try to go back and format it as text, it won't
change it.

 

[Guest]

Hi
Use the arrowkeys to go to the cell. Then click Insert<hyperlink<remove
hyperlink.
Hope it works

 

[Guest]

Thank you! It worked!

Hi
Use the arrowkeys to go to the cell. Then click Insert<hyperlink<remove
hyperlink.
Hope it works

--
Therese


"debanded" skrev:

 

[John James]

Hi debanded,

Select:

Tools-Autocorrect options - Autoformat as you type

Uncheck the box labelled replace as you type Internet and network paths
with hyperlinks

If you enter a new email address after this change, you won't get
hyperlinks. Copy and paste-special-formats this over existing links to
remove the links.