View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default How to delete/change the formula of a cell and yet retain its cont

I think you want Copy,Paste Special--Values.

Test first!

"Hispanglo Sam" wrote:

I want to COPY a whole column of cells from a sheet where each cell in the
column is programmed =sum of previous row of cells, then PASTE the whole
column of results into another sheet where they will function simply as
starting values for a new calculation, i.e. without formula "=sum(a:b . . .)".

Problem: After pasting the column of cells into their new destination, I
don't know how to delete (or change) their now-inappropriate original formula
without losing their contents.