View Single Post
  #1   Report Post  
ocbecky
 
Posts: n/a
Default I want the results of a formula to show in cell, NOT THE FORMULA!

I have the new excel program and I can't figure out how to get the results of
a formula to show in the cell instead of the formula itself. The old program
displayed the results! That is what I want, how do I do that?
ie....=SUMPRODUCT(+D3+D4+D5+D7+D8) should be xyz dollars, not
.....=SUMPRODUCT(+D3+D4+D5+D7+D8). ARRRGGHHHHH