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