If you press CTRL+Z immediately after Excel does the conversion, it will be
reversed.

Otherwise, you could use a macro to remove all hyperlinks after the fact.

Sub RemoveHyperLinks()
Dim HL As Hyperlink
With ActiveSheet
If .Hyperlinks.Count < 0 Then
For Each HL In ActiveSheet.Hyperlinks
HL.Delete
Next HL
End If
End With
End Sub



On Fri, 4 Mar 2005 17:45:02 -0800, Jim in Berkeley <Jim in
wrote:

When I type an email address into a cell in Excel, it automatically becomes a
hyperlink and defaults to 10-point font. While that may be convenient at
times, I also want to prepare a list of email addresses that is NOT
hyperlinked. Even when I set the style for the column to be Normal instead of
Hyperlink, as soon as I type an email address it defaults to Hyperlink style.
How do I stop that?