hidden result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eggpap - 25 Mar 2008 19:19 GMT

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

Reply to this Message

Dave Peterson - 25 Mar 2008 19:44 GMT

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.

> hello,
> in one complex Excel 2003 application some formulas stopped to show their
[quoted text clipped - 4 lines]
>
> Thanks, Emiliano

Signature

Dave Peterson

Reply to this Message