Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula is displayed instead of the result
I clear a cell by going to edit menu, clear all.
write a simple formula such as ='SI Data work'!B2, this works fine and shows the value. now if I go and change B2 to C2 in the formul, it does not work, if shows the formula as string. I have a lot of formulas in a row and this is making me retype each and every formula. Thanks in Advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a formula read a result rather than a formula | Excel Discussion (Misc queries) | |||
Formula partial result displayed in cell | Excel Discussion (Misc queries) | |||
formula result not displayed | Excel Discussion (Misc queries) | |||
formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |