Can I retain the formats in a pivot when expanded to additional wo

J

Jeanie34

I have a Pivot Table, in which I have set set the formats to %'s on the
majority of columns.

However when I double click on a cell, which creates a new worksheet showing
the expanded data, the data shows as decimals.

Is there a way of retaining the formats in the Pivot when the new sheet is
created?

Thanks
 
Top