Formulas do not generate result until formula edited

[Harry @ Creel]

We utilize a multi-page workbook in Excel 2003. All updates are installed.
Recently, random formulas are not yielding a result, rather show a default -
for 'zero'. Not all formulas are the same type, e.g. round or sum, nor will
they necessarily repeat. Calculation is set to Automatic, no files have
Calculation set to Manual, no macros are used. F6 is depressed to refresh
formulas, but yields no result. Nor does F8.

Their are two methods we have found to yield a result: 1) edit the formula,
by replacing at least one character with the same character - generally we
replace the = sign with itself, depress Enter and the formula yields a
result; 2) right click the worksheet tab, copy to another sheet, and ALL
formulas yield results.

 

[J Sedoff comRemove>]

Random Guess: Check your cell formatting, it sounds like you might have the
Accounting format on.

Right-click on cells of interest, "Format Cells," under the "Number" tab,
change the category to "Number."

Hope this helps, Jim

 

[Harry @ Creel]

Jim,

Thanks for your recommendation. The cell formats are set for numbers...

 

[Dave Peterson]

I would try selecting all the cells (instead of one at a time) and doing:

Edit|replace
what: =
with: =
replace all

Maybe it'll wake up excel's calculation engine for good???

ps. For a single cell, it should be enough to:
Hit F2 and then hit enter
to force excel to reevaluate that cell.