| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
never before formula
While referensing a cell in another worksheet in the same file with a
formula, some cells won't do it. Instead they just show the formula as typed like "=Appl!C2". Why? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
never before formula
The cell is probably formatted as TEXT.
Select the cell in question Format as GENERAL With the cell still selected press function key F2 then hit ENTER -- Biff Microsoft Excel MVP "Fritz" wrote in message ... While referensing a cell in another worksheet in the same file with a formula, some cells won't do it. Instead they just show the formula as typed like "=Appl!C2". Why? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
