software

How do I disable automatic hyperlinks when entering data in Excel (2000)?
When entering email addresses that I don't want automatically converted to
hyperlinks, I hate having to go back over each one to remove the hyperlink.
Help!

On the Tools menu, click AutoCorrect Options
On the 'AutoFormat As You Type' tab, clear the check box corresponding to
the 'Internet and network path for hyperlinks' option
--
Hope this Helps!
Camilo

Objective: To help one person each day!

Feedback is greatly appreciated! Please let me know if I've answered your
question or if my post was helpful to you?quot;Terry Wquot; wrote:

gt; How do I disable automatic hyperlinks when entering data in Excel (2000)?
gt; When entering email addresses that I don't want automatically converted to
gt; hyperlinks, I hate having to go back over each one to remove the hyperlink.
gt; Help!

It is under your Autocorrect options.

Tools--gt;Autocorrect options--gt;Autoformat as you type--gt;Internet and network
links as you typel
quot;Terry Wquot; wrote:

gt; How do I disable automatic hyperlinks when entering data in Excel (2000)?
gt; When entering email addresses that I don't want automatically converted to
gt; hyperlinks, I hate having to go back over each one to remove the hyperlink.
gt; Help!

Hi, Camilo! Unfortunately, my version of Excel doesn't have the 'AutoFormat
As You Type' tab. Any other suggestions? The closest option available in 2000
version is a check box, quot;Replace text as you type.quot; I unchecked it and that
didn't work either.

Thanks for helping out!
TW

quot;Camiloquot; wrote:

gt; On the Tools menu, click AutoCorrect Options
gt; On the 'AutoFormat As You Type' tab, clear the check box corresponding to
gt; the 'Internet and network path for hyperlinks' option
gt; --
gt; Hope this Helps!
gt; Camilo
gt;
gt; Objective: To help one person each day!
gt;
gt; Feedback is greatly appreciated! Please let me know if I've answered your
gt; question or if my post was helpful to you?
gt;
gt;
gt; quot;Terry Wquot; wrote:
gt;
gt; gt; How do I disable automatic hyperlinks when entering data in Excel (2000)?
gt; gt; When entering email addresses that I don't want automatically converted to
gt; gt; hyperlinks, I hate having to go back over each one to remove the hyperlink.
gt; gt; Help!

If you type these you can precede the enrty with an apostrophe ' and it
won't have an active link, the apostrophe is not visible in the cell--Regards,

Peo SjoblomNorthwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address
quot;Terry Wquot; gt; wrote in message
...
gt; Hi, Camilo! Unfortunately, my version of Excel doesn't have the
gt; 'AutoFormat
gt; As You Type' tab. Any other suggestions? The closest option available in
gt; 2000
gt; version is a check box, quot;Replace text as you type.quot; I unchecked it and
gt; that
gt; didn't work either.
gt;
gt; Thanks for helping out!
gt; TW
gt;
gt; quot;Camiloquot; wrote:
gt;
gt;gt; On the Tools menu, click AutoCorrect Options
gt;gt; On the 'AutoFormat As You Type' tab, clear the check box corresponding to
gt;gt; the 'Internet and network path for hyperlinks' option
gt;gt; --
gt;gt; Hope this Helps!
gt;gt; Camilo
gt;gt;
gt;gt; Objective: To help one person each day!
gt;gt;
gt;gt; Feedback is greatly appreciated! Please let me know if I've answered
gt;gt; your
gt;gt; question or if my post was helpful to you?
gt;gt;
gt;gt;
gt;gt; quot;Terry Wquot; wrote:
gt;gt;
gt;gt; gt; How do I disable automatic hyperlinks when entering data in Excel
gt;gt; gt; (2000)?
gt;gt; gt; When entering email addresses that I don't want automatically converted
gt;gt; gt; to
gt;gt; gt; hyperlinks, I hate having to go back over each one to remove the
gt;gt; gt; hyperlink.
gt;gt; gt; Help!