Tried the mailto:..... and no soap, doesn't work. The ones that do work and
the ones that don't work are all formated the same as "General". I tried the
on several of the addresses.

"JLatham" wrote:

Try typing mailto: in front of one of the entries that hasn't converted to a
hyperlink format and let us know if it remains text or changes to a link.
That will clue us in on how to fix this. For example if you have

change it to

no spaces anywhere in there.

Also choose one of the non-linking entries and choose Format | Cells and see
what specific format is assigned to it - let us know.
"Pat" wrote:

I checked the "Internet and network paths with hyperlinks" was already checked.
This is driving me nuts, because the sheets I am preparing need these as
hyperlinks and I can find no way to fix it.

"Elkar" wrote:

Try selecting "AutoCorrect Options" from the TOOLS Menu. Then select the
"AutoFormat As You Type" tab. Check the box called "Internet and network
paths with hyperlinks".

HTH,
Elkar


"Pat" wrote:

when I type an email address it should be recognized, but about 1/3 of the
time it does and the rest it does not. If it does not and I right click on
the cell "hyperlink" is greyed out. Any suggestions to solving this problem?