Nick
The problem is resolved although I don't know how. When I opened the file
today the zeros had been replaced by the formula result. This seems to be an
intermittent bug. I've had previous problems where Excel displays the
formula instead of the result. This time it displayed the zero instead of
the result. It is not consistent across all cells in the spreadsheet.
Reformatting, unlocking, etc. haven't corrected the problem. The formula
results just re-appears, sometimes after a close and open. Sometimes after a
recalc. Sometimes after switching from one spreadsheet to another, or one
tab to another. I haven't been able to identify a repeating pattern to the
problem.
thanks
