E-mail addresses executing

[Frank Shelledy]

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?

 

[Bobocat]

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

 

[Bill Sharpe]

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?

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

 

[Gord Dibben]

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