turning hyperlink off

[rockhammer]

Is there a way to turn off hyperlink for an excel file so that manually
entering data in the spreadsheet will not convert the text into hyperlinks
when the data looks like a web address or an email address? Thanks.

 

[Jim Cone]

Tools | Auto Correct Options | AutoFormat As You Type (tab)

Helpful advice here... http://www.cpearson.com/excel/newposte.htm
'--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"rockhammer"
wrote in message
Is there a way to turn off hyperlink for an excel file so that manually
entering data in the spreadsheet will not convert the text into hyperlinks
when the data looks like a web address or an email address? Thanks.

 

[Gary''s Student]

Tools > Options > Spelling > AutoCorrect Options > and uncheck Internet and
network paths

This only affects what you type and not what already exists on the sheet

 

[rockhammer]

Wonderful, Jim. Thanks.

 

[rockhammer]

Thanks a lot, Gary.

Tools > Options > Spelling > AutoCorrect Options > and uncheck Internet and
network paths

This only affects what you type and not what already exists on the sheet