I have many email addresses which I have already entered in a column. I
want them to be as text not hyperlinks.

some cells in that column are empty and some have email addresses I
want those emails (which are now hyperlinks) to be as text and those as
well which I enter later.
how could this be done?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=556472