How to copy the value and not formula of a cell

Hi

I hope this is not too basic a question but I am a new user!

I have a sheet and I want to copy the value of one field into a new cell but when I do this I copy the formula which is in the field. i.e

A+B=C (C has the formula to add A and B) I now want to copy the resulting value of C into a new cell (E) how do I do this without copying the formula?

Any help appreciated

Instead of using Paste, use Paste Special, then select the Values option.

Hope this helps,
theDude

Hi thank you for the reply, I have just noticed I did not explain an important part of my problem.

I know I can paste the value from the paste special menu but what I need to do is have a new formula set-up in the new field which will always copy the value of the other cell as it changes.

i.e

A+B=C

C contains the formula A+B

In a new cell (D) I need a new formula which will copy the vaue of C. D needs to have a formula as it is a stock sheet and the value of C will change weekly so it would be easier if D also changed with a formula.

Hope I have not made this too complicated

If A1+B1=C1, do you want D1 to show the same value as C1? In which case, in D1 put: =C1 This points D1 at C1 and both will always show the same value. Or do you want to do more than this?

Originally Posted by cycling-rod

If A1+B1=C1, do you want D1 to show the same value as C1? In which case, in D1 put: =C1 This points D1 at C1 and both will always show the same value. Or do you want to do more than this?

Hi

I tried that but D1 always shows 0 , is this because it is reading the formula which is in C1 (A1+B1) and not the value which it needs too?

No, it is not.
When you put =C1 in the cell D1, it will always reflect the value present in C1.

One problem could be that the formating of D1 is not the same as that of C1 and if C1 has a value like 0.12 and D1 is formatted as a number with zero decimals, then D1 will display 0. Is this your case. Please tell what your values are.

- Mangesh