The formula shows in cell but not the result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I received a read-only excel spreadsheet with information that I needed
to perform a Vlookup. I copied the excel spreadsheet over to a new workbook
in order to save the integrity of the original spreadsheet. The new sheet
does not show protection "Tools/Protection", but when I type in the VLOOKUP
formula, the formula appears in the cell, not the results. I have changed
the cell format from text to general, with no results. I also tested the
count function and this also shows the formula and not the results.

Does anyone know what may be going on with this worksheet causing it to not
display results, but rather the formula itself.
 
After changing the format from text to general, you need to re-enter the
formula. Simply selecting the cell, pressing F2, and then Enter should do it.
 

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

Excel 2007 Not returning formula result 2
VLOOKUP 2
Displaying results in formula bar when cell is hidden 1
VLOOKUP formula displays in cell, will not return data 1
VLookup - result (cell) shows formula, not lookup data 5
Cell shows the last typed text, no matter where it is typed 0
Formula Results 2
How to show all formulas of cells in cells (and not the calculated result) ? 10

Back
Top