Excel formula not displaying target data
 

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)

Excel formula not displaying target data
 

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.

--
Regards,

OssieMac


"Madi362" wrote:

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)

Excel formula not displaying target data
 

On Feb 20, 2:36*pm, Madi362 wrote:
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)

Or press CTRL ~

It might be that.

Excel formula not displaying target data
 

On Feb 20, 3:24*pm, Greg Glynn wrote:
On Feb 20, 2:36*pm, Madi362 wrote:

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)

Or press CTRL ~

It might be that.

(Or more correctly, it is Ctrl `) - [' is the key to the left of the
number 1]