software

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.

Hi
Use the arrowkeys to go to the cell. Then click Insertlt;hyperlinklt;remove
hyperlink.
Hope it works

--
Theresequot;debandedquot; skrev:

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

Thank you! It worked!

quot;Theresequot; wrote:

gt; Hi
gt; Use the arrowkeys to go to the cell. Then click Insertlt;hyperlinklt;remove
gt; hyperlink.
gt; Hope it works
gt;
gt; --
gt; Therese
gt;
gt;
gt; quot;debandedquot; skrev:
gt;
gt; gt; I am creating a spreadsheet that includes e-mail addresses. When I enter the
gt; gt; e-mail address into the cell, it automatically creates a link that I can
gt; gt; click on to send an e-mail. I would like to just have the e-mail address
gt; gt; entered as text, but when I try to go back and format it as text, it won't
gt; gt; change it.


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.--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=532266