Excel Display formula, not result

[SPenney]

I'm modifying a formula and rather than the result, Excel is displaying
the formula -- Yes, my equals sign is in place still.

The formula I'm modifying is =SUBTOTAL(9,E2:E45) to
=SUBTOTAL(3,E2:E45)

I'd rather not re'run the subtotal again to get the count I need unless
I can get it on the same line as the sum. When I run them separate, I
am getting two groups when I only want one.

SPenney

 

[J.E. McGimpsey]

Your cell may be formatted as Text (which will prevent the parser
from interpreting your leading = sign. If so, reformat as General
and re-edit the formula.

 

[SPenney]

Thanks much. That solved the problem