@ sign not to be treated as an email address

P

phmanatee

I'm using the @ sign and Excel insists on treating it as an email address,
when I don't want it to. How can I turn this off?
 
K

Kiba

The easiest way thing to do is move your mouse over the cell and click the
arrow for the drop down menu on the lightning icon that appears and tell it
to stop automatically creating hyperlinks. Or under the tools tab go to auto
correct. select the auto format as you type tab and uncheck the box for
"Internet and network paths with hyperlinks".
 
M

MikeC

I don't know if this works in all versions, but when I had that similar
problem I placed an apostrophe ( ' ) infront of whatever you have. It works
for me, but I'm sure that there is a better answer somewhere floating around
on this website.

Good luck,
MikeC
 
R

Ron de Bruin

In Excel 2002 and up you can disable this

Tools>AutoCorrect options
See the autoformat as you type tab

You can also start with a ' when you start typing
Or use Ctrl z after you enter
 
R

Ron de Bruin

In Excel 2007 :

Office buttton
Excel options
Proofing
Autocorrect options
Autoformat as you type tab
 
K

keil1220

I'm using the @ sign and Excel insists on treating it as an email address,
when I don't want it to. How can I turn this off?
Click to expand...

put a " ' " in front of the formula/string of text, that usually turns-
off any functions.
 
Top