Copy then paste specialvalues.

Now delete the original columns.


Gord Dibben MS Excel MVP

On Sat, 21 Feb 2009 07:50:01 -0800, spitfiregp34
wrote:

I am trying to copy a column of cells that I have summed from other columns.
I then want to erase the other columns, but then when I do this the copied
column all goes to zero. Is there a way to keep the values in the copied
column after I erase the original?