Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Copying formula result to another cell.
2 views
Skip to first unread message
Willy Ngamoki
Oct 1, 2003, 6:55:31 PM10/1/03
to
How do you copy the result of a formula to another cell
leaving just the result without the formula?
leaving just the result without the formula?
J.E. McGimpsey
Oct 1, 2003, 7:25:12 PM10/1/03
to
One way:
Edit/Paste Special, selecting the values radio button.
In article <20f501c3886f$1d9d2090$a001...@phx.gbl>,
Paul Laska
Oct 1, 2003, 7:30:25 PM10/1/03
to
You could put a simple formula where you want the result
to appear. For example if you SUM(A1:A10) in cell A11,
you could copy the results of A11 into G1 by putting the
following formula in G11:
to appear. For example if you SUM(A1:A10) in cell A11,
you could copy the results of A11 into G1 by putting the
following formula in G11:
=A11
If you're trying to do it with the cut/copy/paste
functions, I'm afraid I don't know a way around it.
Hope that helps.
-Paul
>-----Original Message-----
>How do you copy the result of a formula to another cell
>leaving just the result without the formula?
>.
>
0 new messages