how do I remove a sum but keep the figures in excel
 

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

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

how do I remove a sum but keep the figures in excel
 

Thanks that worked!

"Stefi" wrote:

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

how do I remove a sum but keep the figures in excel
 

You are welcome! Thanks for the feedback!
Stefi

€žicklnickla€� ezt Ã*rta:

Thanks that worked!

"Stefi" wrote:

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