E-mail addresses executing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Shelledy - 01 Dec 2006 16:27 GMT

I maintain a directory of homeowner association members in Excel. One of the
columns is the e-mail address of each member. Formerly the file was in Excel
97. Moved it to a computer running Excel 2002. Now the new e-mail address
entries are in executable form (excuse ignornace of Internet
terms--hyperlink?), i.e. when I click on the cell, the program attempts to
send an e-mail to that address. This is not what I want. I've tried
formatting the cell differently, to no avail. How do I turn off this
feature, so that the addresses go in as ordinary text?

Reply to this Message

Bobocat - 01 Dec 2006 18:14 GMT

try
copy the email address to another column, then paste special --> value

>I maintain a directory of homeowner association members in Excel. One of
>the columns is the e-mail address of each member. Formerly the file was in
[quoted text clipped - 4 lines]
>formatting the cell differently, to no avail. How do I turn off this
>feature, so that the addresses go in as ordinary text?

Reply to this Message

Bill Sharpe - 02 Dec 2006 17:47 GMT

> I maintain a directory of homeowner association members in Excel. One of the
> columns is the e-mail address of each member. Formerly the file was in Excel
[quoted text clipped - 4 lines]
> formatting the cell differently, to no avail. How do I turn off this
> feature, so that the addresses go in as ordinary text?

Right-click cell(s), select Remove Hyperlink -- for existing entries.
Start your e-mail address with an apostrophe -- for new entries.
For some reason, formatting the cell as text doesn't seem to work.

Bill

Reply to this Message

Gord Dibben - 02 Dec 2006 19:16 GMT

Frank

To get rid of the hyperlinks.

Select an empty cell (never used cell) and copy it (Ctrl+C) then select the
cells or column that you want to remove the hyperlinks from, then Edit, Paste
Special, Add>OK>Esc

To prevent this in future go to Tools>Autocorrect Options>Autoformat as you
type>Replace as you type..

Uncheck "internet and network paths with hyperlinks"

Then you don't have to bother with the apostrophe that Bill suggests.

Gord Dibben MS Excel MVP

>> I maintain a directory of homeowner association members in Excel. One of the
>> columns is the e-mail address of each member. Formerly the file was in Excel
[quoted text clipped - 10 lines]
>
>Bill

Reply to this Message

Rate this thread: