OK, just for an FYI, you can change the e-mail program that your hyperlinks
will open by going to an Internet Explorer window, selecting Tools Internet
Options ? Programs tab and changing the E-mail drop down to select your
desired e-mail type.

To remove hyperlinks from your cells, type 1 into a blank cell and copy the
cell.

Highlight the e-mail addresses in question.

Select Paste Special and click the multiply option buton, then click OK.


"Exceluser2400" wrote:

When I click on a cell that contains an email address Excel automatically
opens Outlook Express and tries to send an email to that address. Once I have
clicked on the cell the formatting changes to blue text with underlining and
becomes a hyperlink. The next time I click that cell it opens Outlook
Express, and I have to wait for that program to finish opening and then close
it. But usually I just need to copy the address to paste it into another
application. How can I remove the hyperlink formatting, and how can I
prevent clicking on the cell from opening Outlook Express? I have found
nothing about this in the Help feature.