Mark Kennedy wrote:
occasionally when I entre a formula in a cell, the result is
entreed in the ell as a hyperlink which seems to open an email window.
I cannot seem to figure out why this is happening.


If you enter, for example, into a cell it will be
recognised as an email address and turned into a mailto: hyperlink.

If you subsequently enter a formula into the same cell, without clearing
the cell first then the hyperlink will still be attached to the cell.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup