FORMULA not RESULT displaying in cell

  • Thread starter Thread starter susie.worden
  • Start date Start date
S

susie.worden

After entering a vlookup formula and hitting enter the
answer is not displayed in the cell, the FORMULA is
displayed. In order to find the result of the formula you
must click the formula button and see the answer on the
formula window. We have checked all formatting
possibilities and locking/passwording options and have
found no explanation. We are not being prompted for a
password nor have any windows come up to tell us the sheet
is protected in any way. We are not rookies in Excel, but
we are stumped!

Thanks for any help/advice you can offer!
 
Have you tried

Tools->Options->View
[Untick] Formulas (under Window Options)

?

That's the first thing that came into my mind...

Hope it helps

-Bob
 
Sure sounds like it's formatted in text.. try copying the formula elsewhere
(from the formula bar), then set the format of the offending cell to number
(or general), then go back in the formula bar and re-paste the formula in.
 
Back
Top