avoid automatic hyperlink creation when entering an e-mail address

[Martin Schüpbach]

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

 

[Dave Peterson]

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

'(e-mail address removed)

 

[Martin Schüpbach]

Hi Dave,

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

Thanks anyhow.

 

[Dave Peterson]

Why?

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

Hi Dave,

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

Thanks anyhow.