Values won't display after altering a formula.

M

Mike O

I am using a Vlookup function that displays the value in the formula drop
down boxes but only displays the formula in the cell when completed.
 
R

Ragdyer

The cell was probably formatted as Text *before* you entered the formula
itself.

Try this on a "bad" formula cell,

Select the cell, then:

<Ctrl> <Shift> <~>,
Then<F2>,
Then<Enter>.

What you did here was,
Keyboard shortcut to re-format the cell to General,
Then re-entered the formula.
 
Top