Hi all.
Got a weird one here.
What would cause a cell that contains a formula (which should translate to some value on another sheet), to only display the formula and not 'turn over' to show the value it should translate to.
I have other cells on the sheet that used to do this corectly, but now if I copy their existing formula, then clear out the cell, then past that formula back in, it shows only the formula.
thanks, joe
Got a weird one here.
What would cause a cell that contains a formula (which should translate to some value on another sheet), to only display the formula and not 'turn over' to show the value it should translate to.
I have other cells on the sheet that used to do this corectly, but now if I copy their existing formula, then clear out the cell, then past that formula back in, it shows only the formula.
thanks, joe