hidden results

  • 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
 
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
Click to expand...

Check that the cell is formatted to "General" ... not "Text" - you
could try hitting F9 (re-calculate), if the first didn't work.

Chris
 
Check your other post, too.
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
Click to expand...
 

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 result 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Conditional Formatting macro: simple, but doesn't work 6
Row number changes in conditional format formula during VB executi 2
Excel Excel 2007 won't stop rounding down my formula results! 5
Conditional formatting (by Formula) - few questions 15
conditional formatting of cells based on result in hidden cell 1

Back
Top