Hi Folks
This is a quick post.
When I input say:
[email protected] in the cell its reverts to a hyperlink which I dont want. How do I prevent this and I just want to show it as text ONLY?
Thanks
Hi Folks
This is a quick post.
When I input say:
[email protected] in the cell its reverts to a hyperlink which I dont want. How do I prevent this and I just want to show it as text ONLY?
Thanks
Hi sunshine,
Here is a very quick answer.
https://answers.microsoft.com/en-us/...c-68b599b31bf5
I also believe if you put a single quote in front of a typed in email name it will not hyperlink it.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks for that.
I think I found a better way. See below:
On the Excel Ribbon, click the File tab, then click Options.
Click the Proofing category, and click the AutoCorrect Options button.
On the AutoFormat As You Type tab, remove the check mark from Internet and network paths with hyperlinks.
Click OK, twice, to close the dialog boxes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks