Calculation results as static data not formula.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tcidawn - 11 Sep 2007 20:48 GMT

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

Reply to this Message

JE McGimpsey - 11 Sep 2007 20:50 GMT

One way:

Select column C. Copy. Choose Edit/Paste Special, selecting the Values
radio button. Click OK.

> 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
[quoted text clipped - 8 lines]
>
> Dawn

Reply to this Message

tcidawn - 12 Sep 2007 17:12 GMT

Thank you so much for your help!

> One way:
>
[quoted text clipped - 13 lines]
> >
> > Dawn

Reply to this Message

Teethless mama - 12 Sep 2007 03:00 GMT

In C1: =A1*B1 (hit F9 key instead of hit Enter key)

> 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
[quoted text clipped - 8 lines]
>
> Dawn

Reply to this Message

tcidawn - 12 Sep 2007 17:12 GMT

Thank you so much for your help!

> In C1: =A1*B1 (hit F9 key instead of hit Enter key)
>
[quoted text clipped - 10 lines]
> >
> > Dawn

Reply to this Message