Format Cells to Not Allow Hyperlink

[jasonr17]

Can I format a cell/group of cells to block a hyperlink from being created
when an email address is typed in?

I need the full email address entered, which will used in a merge later on.

But... I simply want the text to appear as text, and not require the need to
remove the hyperlink each time a different email is entered.

Thank You

 

[Jim Cone]

Tools | Auto Correct Options | AutoFormat as you Type (tab)...
uncheck ...paths with hyperlinks
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"jasonr17"
Can I format a cell/group of cells to block a hyperlink from being created
when an email address is typed in?
I need the full email address entered, which will used in a merge later on.
But... I simply want the text to appear as text, and not require the need to
remove the hyperlink each time a different email is entered.
Thank You