@ in cell
 

I need to put an "@" in a cell and it is assuming that is a web address.

How do I turn this off so it just displays the string normally??

Thanks in advance for your help.

wnfisba

@ in cell
 

Right-click on cell and then "Remove hyperlink"

"wnfisba" wrote:

I need to put an "@" in a cell and it is assuming that is a web address.

How do I turn this off so it just displays the string normally??

Thanks in advance for your help.

wnfisba

@ in cell
 

Tools/ AutoCorrect Options/ AutoFormat as you type/ disable the bit about
Internet & network paths.

Otherwise, precede your cell content by an apostrophe to keep it as text.
--
David Biddulph

"wnfisba" wrote in message
...
I need to put an "@" in a cell and it is assuming that is a web address.

How do I turn this off so it just displays the string normally??

Thanks in advance for your help.

wnfisba

@ in cell
 

The conversion is due to a AutoCorrect setting.

See http://www.mcgimpsey.com/excel/nohyperlinks.html


In article ,
wnfisba wrote:

I need to put an "@" in a cell and it is assuming that is a web address.

How do I turn this off so it just displays the string normally??

Thanks in advance for your help.

wnfisba

@ in cell
 

David;
Thanks very much!!!! for your valuable information.
Maperalia

"David Biddulph" wrote:

Tools/ AutoCorrect Options/ AutoFormat as you type/ disable the bit about
Internet & network paths.

Otherwise, precede your cell content by an apostrophe to keep it as text.
--
David Biddulph

"wnfisba" wrote in message
...
I need to put an "@" in a cell and it is assuming that is a web address.

How do I turn this off so it just displays the string normally??

Thanks in advance for your help.

wnfisba