stop creating email link when @ sign is present

I want to stop the autoformatting when the @ sign is used in a field. How can
I stop excel from automatically creating an email link when the @ sign is in
a cell?

Gregg,

This feature can be turned OFF under Tools, AutoCorrect, the second tab,
AutoFormat as You Type, unclick the first option Internet and Network Paths
with Hyperlinks

http://HelpExcel.com

"gregg" wrote:

> I want to stop the autoformatting when the @ sign is used in a field. How can
> I stop excel from automatically creating an email link when the @ sign is in
> a cell?

gregg

You don't say which version of Excel you are running.

With Excel 2002 and 2003.........

Tools>AutoCorrect>AutoFormat as you type. Uncheck the "internet paths etc"

OR after you type the @ sign and hit <ENTER> key, hit CTRL + Z and <ENTER>
again.


Gord Dibben Excel MVP

On Tue, 22 Feb 2005 17:13:03 -0800, "gregg" <gregg@discussions.microsoft.com>
wrote:

>I want to stop the autoformatting when the @ sign is used in a field. How can
>I stop excel from automatically creating an email link when the @ sign is in
>a cell?