hidden result

  • Thread starter Thread starter eggpap
  • Start date Start date
E

eggpap

hello,
in one complex Excel 2003 application some formulas stopped to show their
results.
Moreover, if I cancel the formula and rewrite it, (e.g. =SUM(C10:AG10))
the formula remains written instead of disappearing and formatted like if
a conditional formatting should be applied to the cell.

Thanks, Emiliano
 
Try reformatting the cell as General (or anything but text).

Then re-enter the formula (Select the cell, Hit F2, then Enter should do it).

And if the formula doesn't recalc, make sure you have calculation set to
automatic. (Tools|Options|Calculation tab)

It kind of sounds like you have both situations.
 

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

Similar Threads

hidden results 2
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
hyperlink to cell based on formula results 4
Formula displays as formula, not as result 2
sum by conditional formatted color 2
Conditional Formatting #2 is overwriting #3 3
Eliminating "#VALUE!" for a formula’s results 1

Back
Top