The short answer is no...
--
HTH...

Jim Thomlinson


"Jeanie34" wrote:

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