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?

Please post your formula, inputs and expected result

--

Kind regards,

Niek Otten

Microsoft MVP - Excel

--

Kind regards,

Niek Otten

Microsoft MVP - Excel

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

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

1. How am i able to view the formula bar as I am typing in a cell?

2. Mult formula cell displays "0", which formula created result?

3. Displaying Cell Formulas (without using Tools/Options/View-Formula

4. Formula displays result in formula box but not in cell

5. Cell displays formula not the result of the formula

6. Why doen't PasteSpecial, Formulas not display formula in cell?

7. Cell displays formula instead of the formula's result

8. Cell problem - cell displays formula instead of value

9. Displaying in a cell the formula from another cell

10. Cell reference - displays formula rather then referenced cell

11. Why does my formula bar display a lengthy string, but my cells display #####?

12. Formula for displaying in 1 cell Lowest value from multiple other cells

13. Can a formula in one cell cause something to be displayed in another cell?

14. A formula for displaying the cell reference of the selected cell

15. what is the formula that help when cell=0/cell=0 to be display a .

3 post • Page:**1** of **1**