J
John Quinn
I have Microsoft Excel 97 SR2 Patch on a computer.I will
use an example of pasting not working. I go into a blank
worksheet. In cell b3 I enter 200, in cell c3 I enter 300,
in cell d3, i autosum so the numeric value is 500, the
formula is b3+c3.I click copy when in cell d3 I go to
cell d5 and click paste. the formula for d5 is b5 and c5,
but the numeric value is 500, same as d3. In cell d5, i
have to hit F2 and enter and the value changes to zero,
the correct amount.If I go back to cell b3 and change the
amount from 200 to 300, D5 value does not change to 600, I
have to go d5, hit f2 and enter for numeric value to
change;
use an example of pasting not working. I go into a blank
worksheet. In cell b3 I enter 200, in cell c3 I enter 300,
in cell d3, i autosum so the numeric value is 500, the
formula is b3+c3.I click copy when in cell d3 I go to
cell d5 and click paste. the formula for d5 is b5 and c5,
but the numeric value is 500, same as d3. In cell d5, i
have to hit F2 and enter and the value changes to zero,
the correct amount.If I go back to cell b3 and change the
amount from 200 to 300, D5 value does not change to 600, I
have to go d5, hit f2 and enter for numeric value to
change;