View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default When I click on my cell, it directs to me an email form.......

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.