Formula returned in vlookup function

[87vette]

I've used vlookup for a while now in the office 2003. Just converted to
office 2007. Now when I do a vlookup I get the formula displayed in my
current cell instead of a returned value. I can't figure our what I'm doing
wrong. Can someone help?
Thanks
bmc

 

[Ron@Buy]

You've probably got a tick in the wrong place:
Try Office Button (top left hand corner)
Excel Options (bottom line)
Click on advanced
Scroll down to Display options for this worksheet
and untick 'Show formulas in cells instead of their calculated results
Click OK
Hope this helps

 

[87vette]

It did help Ron. Thanks for the help.

You've probably got a tick in the wrong place:
Try Office Button (top left hand corner)
Excel Options (bottom line)
Click on advanced
Scroll down to Display options for this worksheet
and untick 'Show formulas in cells instead of their calculated results
Click OK
Hope this helps