Prev: Formula help
Next: Formula help--lookup?
From: Rich on 1 Apr 2010 16:54
when I enter a vlookup formula into a cell...I hit enter and the actual
formula stays in the cell...SHOWING. It doesn't give an error message but
just displays the actual formula with no action...Help, please!
From: Gord Dibben on 1 Apr 2010 17:06
Perhaps the cell was formatted as Text.

Format to General then F2 and Enter to re-enter the formula.

Or you are in Formula View and see all formulas as a string.

Hit CTRL + `(backquote above Tab key) to toggle formula view on/off.


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 13:54:01 -0700, Rich <Rich(a)discussions.microsoft.com>
wrote:

>when I enter a vlookup formula into a cell...I hit enter and the actual
>formula stays in the cell...SHOWING. It doesn't give an error message but
>just displays the actual formula with no action...Help, please!

 | 
Pages: 1
Prev: Formula help
Next: Formula help--lookup?