View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default how do I remove a sum but keep the figures in excel

Use Copy from Document/Column F and Pastespecial/Values into different
workbook.

Regards,
Stefi

€˛icklnickla€¯ ezt Ć*rta:

I have set up an excel document where I have values in row E, and have put a
simple formula into row F (example: E3*1.06). Now I want to use the figures I
have got from the sum into a different workbook, but I do not want to show
the formula. Is there anyway of doing this - all I seem to get is error
messages!

Thanks,

Nicola