Excel 2007 Not returning formula result

C

cyberlill

I entered a VLOOKUP formula in a cell using the wizard. In the wizard window,
the correct result is returned but when I hit enter to enter the formula in
the cell, it just displays the formula rather than executing and showing the
result. Is there something in EXCEL 2007 I need to do to get it to execute?
 
T

Tom Hutchins

The cell may have been formatted as Text before you entered the formula. With
the cell selected, change its format to General, then press F2, then Enter.

Hope this helps,

Hutch
 
D

David Biddulph

Make sure that the cell isn't formatted as text. If it is, format as
General, then re-enter the formula (F2 or click in the formula bar, then
enter).
Make sure that you haven't set the option to view formulae (the latter
applies to the whole sheet).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Displays Instead of Result One Column Only 1
VLOOKUP displays formula rather than result Excel 2007 2
VLOOKUP returning #N/A result 2
Excel does not accept text format! 0
Formula Audit mode active in one column only; cannot kill. 2
complicated excel formula may need an algebra wiz 1
Can I add a formula or function to Vlookup? 1
Excel - Wich Function should I use? 1

Top