prevent cell content from being interpreted as a hyperlink?

[keithb]

Is there some way of formatting cells that prevents cell content from being
interpreted as a hyperlink?

Thanks,

Keith

 

[Dave Peterson]

xl2002 added a feature to turn this off.

tools|autocorrect|autoformat as you type tab
uncheck that top box.

If you're using xl2k or below, hit ctrl-z as soon as excel converts it to a
hyperlink.

Or start your entry with an apostrophe:

'www.microsoft.com

 

[keithb]

I have 'inherited' a group of spreadsheets that has cells containing @
symbols, and tools|autocorrect|autoformat replace as you type is unchecked.
Even so, Excel treats these cell as a hyperlink. How can remove the
hyperlink treatement while retaining the cell content?

Thanks,

Keith

 

[Dave Peterson]

Select the range to clean up
(ctrl-a (twice in xl2003) will select the whole sheet.)
then hit alt-f8 (to get to the VBE)
then hit ctrl-g (to see the immediate window)

type this and hit enter
selection.hyperlinks.delete

Then back to excel to see what happened.