Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula error - cell reference
I have a cell that is referencing a cell in another worksheet. However,
instead of showing the value of the referenced cell, it is displaying the actual formula. Does anyone know what the problem is here? I've never had the actual formula appear in a cell before. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula error - cell reference
You probably have your cell formatted as text.
Format as General, then edit the formula (F2, enter) to force it to be recalculated. Regards, Fred "Sara" wrote in message ... I have a cell that is referencing a cell in another worksheet. However, instead of showing the value of the referenced cell, it is displaying the actual formula. Does anyone know what the problem is here? I've never had the actual formula appear in a cell before. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula error - cell reference
On Jan 24, 10:04*am, Sara wrote:
I have a cell that is referencing a cell in another worksheet. *However, instead of showing the value of the referenced cell, it is displaying the actual formula. *Does anyone know what *the problem is here? *I've never had the actual formula appear in a cell before. The format is probably set to TEXT. Right click the cell and change the format to general or number. Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute cell reference and REF error | Excel Discussion (Misc queries) | |||
Inserting current date when number entered in cell & Circular reference error? | Excel Discussion (Misc queries) | |||
Using a cell reference within a cell reference in a formula | Excel Worksheet Functions | |||
circular error w/o cell reference | Excel Discussion (Misc queries) | |||
IF formula reference error | Excel Discussion (Misc queries) |