ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   My cell formula is generating an unwanted e-mail message. (https://www.excelbanter.com/excel-worksheet-functions/50566-my-cell-formula-generating-unwanted-e-mail-message.html)

Rita Major

My cell formula is generating an unwanted e-mail message.
 
I have a column of cells formatted accounting that, when you click on it,
pulls up an e-mail box from Outlook! I changed the formatting to number, and
it still did it with some of the cells. The cell contents read =+SUM(n2:n5).
I took out the + sign and that worked with all of the cells except one. Does
anyone know how to turn off this e-mail function? I would be so grateful.

Gary''s Student

Right-click the cell and make the bottom choise which is remove hyperlink.
--
Gary's Student


"Rita Major" wrote:

I have a column of cells formatted accounting that, when you click on it,
pulls up an e-mail box from Outlook! I changed the formatting to number, and
it still did it with some of the cells. The cell contents read =+SUM(n2:n5).
I took out the + sign and that worked with all of the cells except one. Does
anyone know how to turn off this e-mail function? I would be so grateful.


Rita Major

That worked perfectly. Thank you so much for the correct and timely help. Rita

"Gary''s Student" wrote:

Right-click the cell and make the bottom choise which is remove hyperlink.
--
Gary's Student


"Rita Major" wrote:

I have a column of cells formatted accounting that, when you click on it,
pulls up an e-mail box from Outlook! I changed the formatting to number, and
it still did it with some of the cells. The cell contents read =+SUM(n2:n5).
I took out the + sign and that worked with all of the cells except one. Does
anyone know how to turn off this e-mail function? I would be so grateful.


Lilliabeth


Right-click on it and choose Remove Hyperlink


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=476413


Rita Major

That worked perfectly. Thank you so much. I don't know where that formatting
came from!

"Lilliabeth" wrote:


Right-click on it and choose Remove Hyperlink


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=476413




All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com