Why is it that when I enter a formula in a cell it displays the formula rather than the results of the formula?
It's a pretty simple situation that has caused me problems in the past. I've copied a simple formula from another cell that references another cell (=+A1) and it displays the results correctly. Now if I want the reference to be say A50 and I replace A1 with A50, rather than getting what's in A50, I get =+A50 in the cell. If I just press + and drag the cursor to cell A50 I get the same result.
It's driving me nuts.
Thanks for any help.
Paul
It's a pretty simple situation that has caused me problems in the past. I've copied a simple formula from another cell that references another cell (=+A1) and it displays the results correctly. Now if I want the reference to be say A50 and I replace A1 with A50, rather than getting what's in A50, I get =+A50 in the cell. If I just press + and drag the cursor to cell A50 I get the same result.
It's driving me nuts.
Thanks for any help.
Paul