My cell formula is generating an unwanted e-mail message.

[Rita Major]

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

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

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