View Full Version : Formulas that do not run

04-19-2007, 05:50 AM
I have had this problem before and I am wondering if there is a fix.

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


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


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

Any one know what the problem is?


04-19-2007, 05:56 AM
Is it possible that in Tools>Options>View, the Formulas checkbox is ticked?

04-19-2007, 05:57 AM
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.

04-19-2007, 09:18 AM
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.

04-19-2007, 09:40 AM
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.