Referenced cell shows ='EE-4201-Mp-11'!D3, not the value

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

Guest

Sometimes when I want to reference the value in a cell from another worksheet
I get this in the cell ='EE-4201-Mp-11'!D3. It is showing the worksheet and
the cell and not the value in that cell.

What is causing this. It does not do it all the time.
The format for the cell makes no difference.

I am sure this must be a simple toggle that needs to be set.
 
Sounds like the cell is probably formatted as TEXT. Even though you may have
changed the format to some other type (like NUMBER or GENERAL) the new
format doesn't apply until you edit the cell.

Select the cell in question
Format the cell as GENERAL
With the cell still selected hit function key F2 then hit ENTER.
 
You must log in or register to reply here.

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

Sum the shown values of a cell 4
condionally formatting based on another cells formatting? 2
Referencing a cell 6
Excel Concatenate with line breaks but ignore blank cells 3
Excel 2007 - referencing a cell value from another worksheet withi 6
Automatically copy a cell from one worksheet to another 3
Is Cell D3 within 10% of B3 True or false? 13
Formula in Cell Instead of Result 3

Back
Top