Calculation results as static data not formula.
Thank you so much for your help!
"JE McGimpsey" wrote:
One way:
Select column C. Copy. Choose Edit/Paste Special, selecting the Values
radio button. Click OK.
In article ,
tcidawn wrote:
I know this is an easy one for you wizzes, but it escapes me at the moment
and I never seem to have the right terminology to look up what I am trying to
do.
I have two columns of data (A, B) and a third that is the result of a
calculation of A & B
(A*B=C). I need column C to become static data rather than the formula as
columns A & B will eventually be removed.
I know it's simple - sorry and thanks!
Dawn
|