Lost Formatting When tab is copied

  • Thread starter Thread starter DtTall
  • Start date Start date
D

DtTall

My problem would seem to be very basic. I have a table that has values
with dollars in columns and then a rate (i.e. one cell less another
and then divide) in percentage format. When I copy an existing tab
either into the same workbook or into a new workbook, many of my
percent formats change to dollar format. This happens no matter what
page I copy and it happens on pages that I am not even touching or
copying.

Often times these cells that lose their formatting are next to cells
that are in dollar format that are pulling their data from pivot
table. Could this have anything to do with it?

I copy off tabs on a regular basis to send as an individual workbook,
so I do this often and having to go back and re-format a bunch of
cells is tedious at best. Any thoughts or tips help!

David
 
DtTall,
When you copy, to a new (blank) worksheet, have you tried:
Select the block above "1" and to the left of "A". This selects the new
worksheet.
Edit, Paste Special, then select "values and number formats" ?
hth
 
Yeah, that seems to be the only way to do it. I was just trying to
figure out why it was breaking stuff and changing formats.

Thanks!
 
Back
Top