View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AAA1986 AAA1986 is offline
external usenet poster
 
Posts: 16
Default Copy data ONLY from a function cell

I want to copy and paste the data derived a function in a cell. If I copy the
cell, it will carry the function with it. Is there a way I can copy only the
data (i.e. 98.26) and not the function with it (i.e. =AVERAGE(I3:I6)) to
paste into another cell or non-excel document?

Thanks in advance.