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.

Check out:

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

HTH

"Unknown" wrote in message
...

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.

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

--
Kind regards,

Niek Otten

"Unknown" wrote in message
...

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.

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

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
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

--
Kind regards,

Niek Otten

"Unknown" wrote in message
...

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.

On Sat, 26 Nov 2005 08:39:11 -0500, "JMay" wrote:

,;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

,;HTH
,;
,;"Unknown" wrote in message
...
,;
,; 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.
,;

On Sat, 26 Nov 2005 14:39:42 +0100, "Niek Otten"
wrote:

,;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