When I click on my cell, it directs to me an email form..........w

V

VTHokieTom

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

Kevin B

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

VTHokieTom

Thank you very much!

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

Fred Smith

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

David Biddulph

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) ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top