Is there some way of formatting cells that prevents cell content from being
interpreted as a hyperlink?
Thanks,
Keith
Is there some way of formatting cells that prevents cell content from being
interpreted as a hyperlink?
Thanks,
Keith
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 wrote:
>
> Is there some way of formatting cells that prevents cell content from being
> interpreted as a hyperlink?
>
> Thanks,
>
> Keith
--
Dave Peterson
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" <[email protected]> wrote in message
news:[email protected]...
> 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 wrote:
>>
>> Is there some way of formatting cells that prevents cell content from
>> being
>> interpreted as a hyperlink?
>>
>> 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.
keithb wrote:
>
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 wrote:
> >>
> >> Is there some way of formatting cells that prevents cell content from
> >> being
> >> interpreted as a hyperlink?
> >>
> >> Thanks,
> >>
> >> Keith
> >
> > --
> >
> > Dave Peterson
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks