Stopping hyperlink text

[Pieter van der Walt]

How to I stop Excel from automatically creating a URL for text that I type
into cells? For instance when I type in an email address and press enter, it
automatically changes it into a Hyperlink. I need the text to be just normal
text without hyperlink...

Thanks
Pieter

 

[David Biddulph]

How to I stop Excel from automatically creating a URL for text that I type
into cells? For instance when I type in an email address and press enter,
it automatically changes it into a Hyperlink. I need the text to be just
normal text without hyperlink...

Tools/ AutoCorrect Options/ AutoFormat As You Type:
Deselect "Replace as you type - Internet and network paths with hyperlinks"

 

[Florida User]

Enter an apostrophe ' before you enter the email address

 

[Pieter van der Walt]

Thanks!

Tools/ AutoCorrect Options/ AutoFormat As You Type:
Deselect "Replace as you type - Internet and network paths with
hyperlinks"