You can't turn that off in Excel up through Excel 2000.
You can have a macro immediately wipe out the link as soon as it
is created, but the method is a nuisance.

I would suggest just letting them get created (even if you have Excel 2002 and up)
and then remove all that you don't want all at one time.
Removing object hyperlinks from a Cell or cell range (#DelHyperlinks)
http://www.mvps.org/dmcritchie/excel...#DelHyperlinks

Also contains tips on not taking a hyperlink, like after clicking down
wait before releasing left mouse button, or use the arrow keys.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dwilliams" wrote in message
...

Maybe I should have given the version - excel 2000 - does that make a
difference?

There's a "ToolsAutoCorrect" menu item but not a "ToolsAutoCorrect
OptionsAuto Format as You Type" option.

Under the "ToolsAutoCorrect" I unchecked everthing ( there was nothing
about auto format) but got the same results.


--
dwilliams
------------------------------------------------------------------------
dwilliams's Profile: http://www.excelforum.com/member.php...o&userid=30659
View this thread: http://www.excelforum.com/showthread...hreadid=503211