Copy values but not formulas

savallone · General User Joined: 25 Sep 2008 Posts: 9

I sum a column of cells.
I want to copy the value of that sum but not the formula of that sum to another cell so that when I change one of the addends in the column the total that I copied remains unchanged.

Actually what I have is a row of sums. I want to copy that row of sums to another page without having this other page reflect any changes I make to any addend in any of the columns of the first page.

The best I can do is to manually type the values of the column sums, in say a row below it, and then copy and paste that new row to the other page (because this new row contains no formulas and only the values I want).

Is there a simpler way?

Much appreciation.

JohnV · Posted: Mon Aug 30, 2010 11:09 am Post subject:

Paste Special > Unformatted text

savallone · General User Joined: 25 Sep 2008 Posts: 9

Good.
Many thanks. -S

mudgelings · Newbie Joined: 18 Feb 2010 Posts: 4

Using Paste Special > Unformatted text didn't work for me.
I used Paste Special > Number instead.

For example, my formula was in B9. It subtracted one time-formatted cell from another time-formatted cell to get the number of hours between the two times. What I wanted in the resulting cell was the result of the formula as text, not result of formula as calculated. For the life of me I couldn't find any formula that would accomplish this. But JohnV's answer put me on the right track. (Many thanks!)

I should have gone to the Forum first! That would have saved me a bunch of time.