avoid automatic hyperlink creation when entering an e-mail address

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin Sch?pbach - 01 Oct 2003 09:49 GMT

Hi Cracks,

thought I'm a crack too - until I could not solve the following job:

How can I avoid automatic hyperlink creation when entering an e-mail address
?

Okay - beat me :-)

Martin Sch?pbach

Reply to this Message

Dave Peterson - 02 Oct 2003 03:10 GMT

If I started with a leading apostrophe, I didn't get the hyperlink:

'test@test.com

"Martin Schüpbach" wrote:

> Hi Cracks,
>
[quoted text clipped - 6 lines]
>
> Martin Schüpbach

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

Martin Sch?pbach - 02 Oct 2003 08:39 GMT

Hi Dave,

but then I would have to remove the apostrophe :-(

Thanks anyhow.

> If I started with a leading apostrophe, I didn't get the hyperlink:
>
[quoted text clipped - 10 lines]
> >
> > Martin Sch?pbach

Reply to this Message

Dave Peterson - 03 Oct 2003 03:56 GMT

Why?

It just tells excel to treat this cell as text (as in '01-04).

"Martin Schüpbach" wrote:

> Hi Dave,
>
[quoted text clipped - 23 lines]
> > Dave Peterson
> > ec35720@msn.com

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message