Excel formula not displaying target data

  • Thread starter Thread starter Madi362
  • Start date Start date
M

Madi362

I am trying to point a cell to another cell on a different sheet in a
workbook. Instead of displaying the target data, it is displaying the
formula. I have never had this happen before. EX: (='Shift Analysis'!C5)
 
If the cell is formatted as Text then it will simply display whatever is
typed in and does not act on formulas that are entered.

Format the cell as General.
 
I am trying to point a cell to another cell on a different sheet in a
workbook. Instead of displaying the target data, it is displaying the
formula. I have never had this happen before. EX: (='Shift Analysis'!C5)
Click to expand...

Or press CTRL ~

It might be that.
 

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

Junp start my Select Case Macro 12
Formula appearing as Value in Formula Bar 1
Help needed 0
If then statements 5
Copy value from changing cells without VBA 1
Break points will be ignored in Excel 1
= cell above last entered data 8
Change_Event not responding to change made by formula. 11

Back
Top