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

[offcmanager]

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.

"offcmanager" <[email protected]> wrote in message
news:[email protected]...
>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?

[Ron Coderre]

I think you need to change an autocorrect setting.

Try this:

Tools>Options>Spelling 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?

Hi again!

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

Andy.

"Ron Coderre" <[email protected]> wrote in message
news:[email protected]...
>I think you need to change an autocorrect setting.
>
> Try this:
>
> Tools>Options>Spelling 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?

[Kevin B]

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" <[email protected]> wrote in message
> news:[email protected]...
> >I think you need to change an autocorrect setting.
> >
> > Try this:
> >
> > Tools>Options>Spelling 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?
>
>
>

[Gary''s Student]

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?