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. |
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. |
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. |
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 |
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