Formulas that do not run

[rcbricker]

I have had this problem before and I am wondering if there is a fix.

I type a formula (usually a vlookup) such as:

=VLOOKUP(D19,$D$19:$E$29,2,0)

And instead of it returning any value it appears exactly as typed, like this:

=VLOOKUP(D19,$D$19:$E$29,2,0)

I can not get the formula to run and I do not know why this happens.

Any one know what the problem is?

Thanks

[Minstrel]

Is it possible that in Tools>Options>View, the Formulas checkbox is ticked?

[Bob Phillips]

The cell is probably formatted as text.

Select the cell, and do Find/Replace (ctrl-H), using values of = and = (yes, the same), and OK it.

[rcbricker]

Yes the formula box was checked under the view tab.

XLD if I run into the problem again and the formula box is not checked I will try your solution.

[Bob Phillips]

No that is a difefrent thing, that means that the view was to show formulae not results. I was referring to where a particular cell is formatted as text.