software

I am trying to enter information in a cell, i.e. 4@50. It keeps turning the
information into an email address. How can I stop this?

Hi

One way is to hit Ctrl Z immediately after it has changed it into an email
address. This will undo the 'helpful' change for you!

Andy.

quot;offcmanagerquot; gt; wrote in message
...
gt;I am trying to enter information in a cell, i.e. 4@50. It keeps turning
gt;the
gt; information into an email address. How can I stop this?
I think you need to change an autocorrect setting.

Try this:

Toolsgt;Optionsgt;Spelling tab
Click the [AutoCorrect Options...] button
Select the quot;AutoFormat as you typequot; tab
Uncheck: Internet and network paths with hyperlinks
Click the [OK] buttons

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;offcmanagerquot; wrote:

gt; I am trying to enter information in a cell, i.e. 4@50. It keeps turning the
gt; information into an email address. How can I stop this?

Hi again!

You could just format the column as Text before you start.

Andy.

quot;Ron Coderrequot; gt; wrote in message
...
gt;I think you need to change an autocorrect setting.
gt;
gt; Try this:
gt;
gt; Toolsgt;Optionsgt;Spelling tab
gt; Click the [AutoCorrect Options...] button
gt; Select the quot;AutoFormat as you typequot; tab
gt; Uncheck: Internet and network paths with hyperlinks
gt; Click the [OK] buttons
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;offcmanagerquot; wrote:
gt;
gt;gt; I am trying to enter information in a cell, i.e. 4@50. It keeps turning
gt;gt; the
gt;gt; information into an email address. How can I stop this?
Or enter an apostrophe prefix to make the entry a label.

Old Lotus relic...
--
Kevin Backmannquot;Andyquot; wrote:

gt; Hi again!
gt;
gt; You could just format the column as Text before you start.
gt;
gt; Andy.
gt;
gt; quot;Ron Coderrequot; gt; wrote in message
gt; ...
gt; gt;I think you need to change an autocorrect setting.
gt; gt;
gt; gt; Try this:
gt; gt;
gt; gt; Toolsgt;Optionsgt;Spelling tab
gt; gt; Click the [AutoCorrect Options...] button
gt; gt; Select the quot;AutoFormat as you typequot; tab
gt; gt; Uncheck: Internet and network paths with hyperlinks
gt; gt; Click the [OK] buttons
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;offcmanagerquot; wrote:
gt; gt;
gt; gt;gt; I am trying to enter information in a cell, i.e. 4@50. It keeps turning
gt; gt;gt; the
gt; gt;gt; information into an email address. How can I stop this?
gt;
gt;
gt;

Another method is to use a single quote (apostrophe) in front:
'4@50
--
Gary''s Studentquot;offcmanagerquot; wrote:

gt; I am trying to enter information in a cell, i.e. 4@50. It keeps turning the
gt; information into an email address. How can I stop this?