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

Precede the entry with an apostrophe '
for example

'xxx@ww

the apostrophe will not be visible in the cell

Best Regards,

Peo Sjoblom

"Simon Corner" wrote:

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

take a look he

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

and

http://www.mcgimpsey.com/excel/nohyperlinks2.html

In article ,
(Simon Corner) wrote:

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.

Simon

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

ToolsAutoCorrectAutoFormat as you type. Uncheck the "internet paths etc"

Gord Dibben Excel MVP

On 30 Nov 2004 09:36:31 -0800, (Simon Corner)
wrote:

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