If you want to delete the hyperlinks...........not the contents, run this
macro.

Sub Delete_Hyperlinks()
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
Cell.Hyperlinks.Delete
Next Cell
End Sub

To prevent future hyperlinking see JP's reply.


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 12:10:02 -0700, bill s <bill
wrote:

How to stop opening outlook in excel when clicking into a cell that contains
an email address.