| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| looking for a formula | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
