software

I'd like to enter email addresses in a certain column as plain text but
it gets automatically formatted in a way that opens Outlook. I just
want to enter something like as plain text without it
turning into a link that opens up an email program. Thanks for any
help.--
dwilliams
------------------------------------------------------------------------
dwilliams's Profile: www.excelforum.com/member.php...oamp;userid=30659
View this thread: www.excelforum.com/showthread...hreadid=503211Hi!

Goto Toolsgt;AutoCorrect Optionsgt;Auto Format as You Type

Uncheck: Internet and network paths with hyperlinks

OK out

Biff

quot;dwilliamsquot; gt; wrote
in message ...
gt;
gt; I'd like to enter email addresses in a certain column as plain text but
gt; it gets automatically formatted in a way that opens Outlook. I just
gt; want to enter something like as plain text without it
gt; turning into a link that opens up an email program. Thanks for any
gt; help.
gt;
gt;
gt; --
gt; dwilliams
gt; ------------------------------------------------------------------------
gt; dwilliams's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30659
gt; View this thread: www.excelforum.com/showthread...hreadid=503211
gt;

Maybe I should have given the version - excel 2000 - does that make a
difference?

There's a quot;Toolsgt;AutoCorrectquot; menu item but not a quot;Toolsgt;AutoCorrect
Optionsgt;Auto Format as You Typequot; option.

Under the quot;Toolsgt;AutoCorrectquot; I unchecked everthing ( there was nothing
about auto format) but got the same results.--
dwilliams
------------------------------------------------------------------------
dwilliams's Profile: www.excelforum.com/member.php...oamp;userid=30659
View this thread: www.excelforum.com/showthread...hreadid=503211gt; Maybe I should have given the version - excel 2000 - does that make a
gt; difference?

Well, I'm using Excel 2002. Sorry, don't know 2000!

Biff

quot;dwilliamsquot; gt; wrote
in message ...
gt;
gt; Maybe I should have given the version - excel 2000 - does that make a
gt; difference?
gt;
gt; There's a quot;Toolsgt;AutoCorrectquot; menu item but not a quot;Toolsgt;AutoCorrect
gt; Optionsgt;Auto Format as You Typequot; option.
gt;
gt; Under the quot;Toolsgt;AutoCorrectquot; I unchecked everthing ( there was nothing
gt; about auto format) but got the same results.
gt;
gt;
gt; --
gt; dwilliams
gt; ------------------------------------------------------------------------
gt; dwilliams's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30659
gt; View this thread: www.excelforum.com/showthread...hreadid=503211
gt;
You can't turn that off in Excel up through Excel 2000.
You can have a macro immediately wipe out the link as soon as it
is created, but the method is a nuisance.

I would suggest just letting them get created (even if you have Excel 2002 and up)
and then remove all that you don't want all at one time.
Removing object hyperlinks from a Cell or cell range (#DelHyperlinks)
www.mvps.org/dmcritchie/excel...#DelHyperlinks

Also contains tips on not taking a hyperlink, like after clicking down
wait before releasing left mouse button, or use the arrow keys.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;dwilliamsquot; gt; wrote in message
...
gt;
gt; Maybe I should have given the version - excel 2000 - does that make a
gt; difference?
gt;
gt; There's a quot;Toolsgt;AutoCorrectquot; menu item but not a quot;Toolsgt;AutoCorrect
gt; Optionsgt;Auto Format as You Typequot; option.
gt;
gt; Under the quot;Toolsgt;AutoCorrectquot; I unchecked everthing ( there was nothing
gt; about auto format) but got the same results.
gt;
gt;
gt; --
gt; dwilliams
gt; ------------------------------------------------------------------------
gt; dwilliams's Profile: www.excelforum.com/member.php...oamp;userid=30659
gt; View this thread: www.excelforum.com/showthread...hreadid=503211
gt;

That covers it.--
dwilliams
------------------------------------------------------------------------
dwilliams's Profile: www.excelforum.com/member.php...oamp;userid=30659
View this thread: www.excelforum.com/showthread...hreadid=503211The autocorrect option affects all worksheets and workbooks.
I have a form that I want OTHERS to use, which asks for an email addresss,
but I don't want Outlook to automatically start when they key the address
into Excel.
Is there a way?

quot;dwilliamsquot; wrote:

gt;
gt; I'd like to enter email addresses in a certain column as plain text but
gt; it gets automatically formatted in a way that opens Outlook. I just
gt; want to enter something like as plain text without it
gt; turning into a link that opens up an email program. Thanks for any
gt; help.
gt;
gt;
gt; --
gt; dwilliams
gt; ------------------------------------------------------------------------
gt; dwilliams's Profile: www.excelforum.com/member.php...oamp;userid=30659
gt; View this thread: www.excelforum.com/showthread...hreadid=503211
gt;
gt;