| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't target cell data changes trigger formula evaluation? | Excel Worksheet Functions | |||
| Why is Excel displaying the formula as text | Excel Worksheet Functions | |||
| linked cell is displaying formula instead of the data | Excel Worksheet Functions | |||
| Displaying target range across the Y axis. | Charts and Charting in Excel | |||
| Excel formula to calculate Target Grade | Excel Programming | |||
Hybrid Mode
