| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell shows formula eg ='Sheet21'!F3 instead of result
I have a problem where when I insert a formula such as ='Sheet21'!F3, the
cell shows the formula, instead of the result. This isn't consistent apparently. I have managed to copy the formula from another cell that works, but when I then change the cell ref (e.g F3 to F4 in the above example), the cell displays the formula again, instead of the result. Cell format is "Text". Is this a cell formatting issue?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell shows formula eg ='Sheet21'!F3 instead of result
<Is this a cell formatting issue??
Yes. Format as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "mikehutt" wrote in message ... |I have a problem where when I insert a formula such as ='Sheet21'!F3, the | cell shows the formula, instead of the result. This isn't consistent | apparently. I have managed to copy the formula from another cell that works, | but when I then change the cell ref (e.g F3 to F4 in the above example), the | cell displays the formula again, instead of the result. Cell format is | "Text". Is this a cell formatting issue?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Formula result not displaying in cell | Excel Worksheet Functions | |||
| Excel shows formula, not result | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
