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