Format email addresses

[Unknown]

I sort an address book of email addresses with excel and it is
annoying to have my email program popup when I click on a cell
containing a blue email address.

I would like to format the cell so that the entry is not recognized by
excel as an email address. Using "text" doesn't do it.

 

[JMay]

Check out:

http://www.mcgimpsey.com/excel/nohyperlinks.html

HTH

 

[Niek Otten]

You probably see a small blue underline just under the normal underline.
Click that, and you'll get the options to turn off automatic creation of
hyperlinks

 

[Niek Otten]

This is Excel 2003; Maybe an option just available in new versions, I can't
check that at the moment

 

[Unknown]

,;Check out:
,;
,;http://www.mcgimpsey.com/excel/nohyperlinks.html

This reference led to a solution. If you go into the auto correct
options you can set the sheet in "Autoformat as you type" so that it
will not create hyperlinks by un-checking the box.

Thanks

 

[Unknown]

,;You probably see a small blue underline just under the normal underline.
,;Click that, and you'll get the options to turn off automatic creation of
,;hyperlinks

Actually I couldn't see that probably due to age and cataracts but it
started me to looking at the right-click options. There is an option
to "remove hyperlink". Unfortunately it will only do one cell at a
time but fortunately I wasn't too far in the list so this was easier
than retyping the list.

The problem is solved.

Thanks