Dave,

I confused the issue.

1. I didn't know the name "hyperlink" so couldn't find how to remove them in
Excel Help.
Embarrassingly, I find I can use the 'Format Painter' to copy simple text
formatting to these hyperlinks and make them into text.

2. I do have additional 'check boxes' and one 'drop down box', which I can
neither delete nor even select.

Thanks for your help.

Steve



"Dave Peterson" wrote in message
...
I thought your symbols were objects--like little icons.

But you mean that they're stock symbols, right?

And you've already deleted the hyperlinks themselves, right?

If both are true...
Select the range
format|Style...
And change to Normal
(don't use Hyperlink style)

If you still have hyperlinks and you want to get rid of them:

Select the range that should have the hyperlinks removed
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete



Steve wrote:

<<snipped

Dave,

Sorry for the late reply.
Your suggestion doesn't work in my case (maybe because I'm using Excel
2000?).

Being more specific, can I change some Excel formatting so that imported
stock symbols which appear in Blue and Underlined (like an internet link
or
URL) are re-formatted as normal text?

Steve

--

Dave Peterson