Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report and then you
copy and paste it to another workbook and you loose the formatting. Is there
any way to avoid this?