cell displays 0 when formula is valid

cell displays 0 when formula is valid

Post by anRv » Thu, 14 Jan 2010 06:51:02


I have a VLOOKUP. The wizard box shows the formula result but it appears as
"0" in the cell. Formatting is general. Why doesn't the result display in
the cell?
 
 
 

cell displays 0 when formula is valid

Post by Niek Otte » Thu, 14 Jan 2010 07:01:13

Please post your formula, inputs and expected result

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

 
 
 

cell displays 0 when formula is valid

Post by anRv » Fri, 15 Jan 2010 02:34:01

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