I have this formula in a column of cells: =+$H3-@Sum(I3:AB3)

Now the entire column of cells has the number which is underlined and when I
point to that cell the following statement appears:

mail to =+$H3-@Sum(I3:AB3) - click once to follow. Click and hold to select
this cell.

How do I get rid of the mail to deal with these cells?

Confused in Virginia. Thanks for the help.

You have hyperlinks in the cell. Right click on the cell w/the hyperlink(s)
and select REMOVE HYPERLINK from the short cut menu
--
Kevin Backmann


"VTHokieTom" wrote:

I have this formula in a column of cells: =+$H3-@Sum(I3:AB3)

Now the entire column of cells has the number which is underlined and when I
point to that cell the following statement appears:

mail to =+$H3-@Sum(I3:AB3) - click once to follow. Click and hold to select
this cell.

How do I get rid of the mail to deal with these cells?

Confused in Virginia. Thanks for the help.

Thank you very much!

"Kevin B" wrote:

You have hyperlinks in the cell. Right click on the cell w/the hyperlink(s)
and select REMOVE HYPERLINK from the short cut menu
--
Kevin Backmann


"VTHokieTom" wrote:

I have this formula in a column of cells: =+$H3-@Sum(I3:AB3)

Now the entire column of cells has the number which is underlined and when I
point to that cell the following statement appears:

mail to =+$H3-@Sum(I3:AB3) - click once to follow. Click and hold to select
this cell.

How do I get rid of the mail to deal with these cells?

Confused in Virginia. Thanks for the help.

Then take out the @ sign. That's a holdover from Lotus 123. The proper Excel
format for your equation is:
=$H3-SUM(I3:AB3)

Regards,
Fred.

"VTHokieTom" wrote in message
...
Thank you very much!

"Kevin B" wrote:

You have hyperlinks in the cell. Right click on the cell w/the
hyperlink(s)
and select REMOVE HYPERLINK from the short cut menu
--
Kevin Backmann


"VTHokieTom" wrote:

I have this formula in a column of cells: =+$H3-@Sum(I3:AB3)

Now the entire column of cells has the number which is underlined and
when I
point to that cell the following statement appears:

mail to =+$H3-@Sum(I3:AB3) - click once to follow. Click and hold to
select
this cell.

How do I get rid of the mail to deal with these cells?

Confused in Virginia. Thanks for the help.

With the @ symbol in there, Excel thinks it is an e-mail address, so has
inserted a hyperlink. What did you intend the @ symbol to do in your
formula? Similarly what did you intend the leasing + symbol after the =
sign to do? I wonder whether you are using relics from another spreadsheet
package?

Perhaps you intended =$H3-Sum(I3:AB3) ?
--
David Biddulph


"VTHokieTom" wrote in message
...
I have this formula in a column of cells: =+$H3-@Sum(I3:AB3)

Now the entire column of cells has the number which is underlined and when
I
point to that cell the following statement appears:

mail to =+$H3-@Sum(I3:AB3) - click once to follow. Click and hold to
select
this cell.

How do I get rid of the mail to deal with these cells?

Confused in Virginia. Thanks for the help.