@ in cell

[wnfisba]

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

 

[Toppers]

Right-click on cell and then "Remove hyperlink"

 

[David Biddulph]

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.

 

[JE McGimpsey]

The conversion is due to a AutoCorrect setting.

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

 

[maperalia]

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