avoid automatic hyperlink creation when entering an e-mail address

  • Thread starter Thread starter Martin Schüpbach
  • Start date Start date
M

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
 
If I started with a leading apostrophe, I didn't get the hyperlink:

'(e-mail address removed)
 
Hi Dave,

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

Thanks anyhow.
 
Why?

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

Martin Schüpbach said:
Hi Dave,

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

Thanks anyhow.
Click to expand...
 
Back
Top