mail to format

[Bob Oneal]

When I enter an email address in a cell, it is automatically converted to a
"mail to" format so selecting this cell opens my email application.
I don't want this to happen. How do I turn off the "mail to" feature??

 

[Elliott Roper]

When I enter an email address in a cell, it is automatically converted to a
"mail to" format so selecting this cell opens my email application.
I don't want this to happen. How do I turn off the "mail to" feature??

That is probably being caused by "autoformat as I type" or one of its
seven horrid sisters.

Hop into preferences or format->autoformat and turn off everything you
don't need, especially replace.. internet paths with hyperlinks.

As a working principle, bin the whole evil empire of autoformat, then
turn on one or two things you think you might really *really* need -
very gingerly.

Round here, the only thing turned on is smart quotes. In spite of its
hubris encrusted name, it is fairly OK.

 

[Guest]

-----Original Message-----


That is probably being caused by "autoformat as I type" or one of its
seven horrid sisters.

Hop into preferences or format->autoformat and turn off everything you
don't need, especially replace.. internet paths with hyperlinks.

As a working principle, bin the whole evil empire of autoformat, then
turn on one or two things you think you might really *really* need -
very gingerly.

Round here, the only thing turned on is smart quotes. In spite of its
hubris encrusted name, it is fairly OK.

--
I thought I would be the last on earth to mangle my e-mail address.
fsnospam$elliott$$
.
I made a mistake and posted my EXCEL problem in the WORD forum.

I cannot find a selection in Excel preferences to stop the automatic "mail to"
when I enter an email address in a cell.

 

[Beth Rosengard]

I made a mistake and posted my EXCEL problem in the WORD forum. I cannot find
a selection in Excel preferences to stop the automatic "mail to" when I enter
an email address in a cell.

You may get an answer here but, if not, post your question to the Excel
newsgroup: microsoft.public.mac.office.excel

When you do (if you haven't already), title the post something like "Remove
hyperlinks in cells". In fact you should Google the Excel newsgroup first
(www.google.com - Groups - Advanced Groups Search); I'll bet you're not the
first person to ask the question.

--
Beth Rosengard
Mac MVP

Mac Word FAQ: <http://word.mvps.org/FAQs/WordMac/index.htm>
Entourage Help Page: <http://www.entourage.mvps.org/toc.html>

 

[John McGhie [MVP - Word]]

Ooops: Things we forgot!! As far as I can tell, there is no way to turn
this off in EXCEL. There is in Word.

I am "pretty certain" this will NOT be fixed in the next version

If you hit Command + Z immediately after it has happened, Excel will undo
just the conversion to a hyperlink.

Sorry

This responds to article <[email protected]>, from
"(e-mail address removed)" <[email protected]>

I cannot find a selection in Excel preferences to stop the automatic "mail to"
when I enter an email address in a cell.

--

Please respond only to the newsgroup to preserve the thread.

John McGhie, Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. GMT + 10 Hrs
+61 4 1209 1410, mailto:[email protected]

 

[Paul Berkowitz]

J.E. McGimpsey suggested some ways to do it in Excel in one of the other
newsgroups. He has them listed and described on his website:

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

--
Paul Berkowitz
MVP Entourage
Entourage FAQ Page: <http://www.entourage.mvps.org/toc.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Entourage you are using - **2004**, X
or 2001. It's often impossible to answer your questions otherwise.

From: "John McGhie [MVP - Word]" <[email protected]>
Newsgroups: microsoft.public.mac.office.word
Date: Fri, 14 May 2004 18:37:10 +1000
Subject: Re: mail to format

Ooops: Things we forgot!! As far as I can tell, there is no way to turn
this off in EXCEL. There is in Word.

I am "pretty certain" this will NOT be fixed in the next version

If you hit Command + Z immediately after it has happened, Excel will undo
just the conversion to a hyperlink.

Sorry

This responds to article <[email protected]>, from
"(e-mail address removed)" <[email protected]>

I cannot find a selection in Excel preferences to stop the automatic "mail
to"
when I enter an email address in a cell.

--

Please respond only to the newsgroup to preserve the thread.

John McGhie, Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. GMT + 10 Hrs
+61 4 1209 1410, mailto:[email protected]