You can use the format painter on Excel's formatting toolbar to copy the
formatting from the source data, and format the details.

GillianHG wrote:
Hi all,

Does anyone know how to format the drill to details table that comes up when
you double-click a pivot table report so that it generates using specific
formats? For example, if there are dates in the Pivot Table, have them
appear in a certain format or have numbers show as currency. The source data
is formatted so this occurs but when the pivot table drill to details sheet
appears, the formatting is completely different.

I have searched everywhere I can think of for an answer to this. Help would
be GREATLY appreciated!!

Thank you!
Gillian


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html