Excel Hyperlinks

S

Simon Corner

Dear All,

Does anyone know how to stop Excel automatically creating hyperlinks?
I use the @ sign a lot for other reasons and it's driving me nut's.

Thanks,

Simon
 
P

Peo Sjoblom

Precede the entry with an apostrophe '
for example

'xxx@ww

the apostrophe will not be visible in the cell

Best Regards,

Peo Sjoblom
 
G

Gord Dibben

Simon

With Excel 2002 and 2003.........

Tools>AutoCorrect>AutoFormat as you type. Uncheck the "internet paths etc"

Gord Dibben Excel MVP
 
Top