Can you enter @ symbol without becomig email address in a cell?
 

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?

Can you enter @ symbol without becomig email address in a cell?
 

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.

"offcmanager" wrote in message
...
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?

Can you enter @ symbol without becomig email address in a cell?
 

I think you need to change an autocorrect setting.

Try this:

ToolsOptionsSpelling tab
Click the [AutoCorrect Options...] button
Select the "AutoFormat as you type" tab
Uncheck: Internet and network paths with hyperlinks
Click the [OK] buttons

Does that help?

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

XL2002, WinXP-Pro


"offcmanager" wrote:

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?

Can you enter @ symbol without becomig email address in a cell?
 

Hi again!

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

Andy.

"Ron Coderre" wrote in message
...
I think you need to change an autocorrect setting.

Try this:

ToolsOptionsSpelling tab
Click the [AutoCorrect Options...] button
Select the "AutoFormat as you type" tab
Uncheck: Internet and network paths with hyperlinks
Click the [OK] buttons

Does that help?

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

XL2002, WinXP-Pro


"offcmanager" wrote:

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?

Can you enter @ symbol without becomig email address in a cell
 

Or enter an apostrophe prefix to make the entry a label.

Old Lotus relic...
--
Kevin Backmann


"Andy" wrote:

Hi again!

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

Andy.

"Ron Coderre" wrote in message
...
I think you need to change an autocorrect setting.

Try this:

ToolsOptionsSpelling tab
Click the [AutoCorrect Options...] button
Select the "AutoFormat as you type" tab
Uncheck: Internet and network paths with hyperlinks
Click the [OK] buttons

Does that help?

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

XL2002, WinXP-Pro


"offcmanager" wrote:

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?

Can you enter @ symbol without becomig email address in a cell?
 

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


"offcmanager" wrote:

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?