Re: Format Drill to Details Table

Tech-Archive recommends: Fix windows errors by optimizing your registry

Heck, that's what I was afraid of.

Thanks for your help, Debra!
--
Warm regards,
GillianHG


"Debra Dalgleish" wrote:

> Unfortunately, there's no way to control the output as it's being created.
>
> GillianHG wrote:
> > Actually, what I meant is I would like it to generate in that format already,
> > not format after the fact. The pivot table shows expenses for the quarter
> > and the executives double-click their department to see their detail data. I
> > would like that detail data to generate as currency, proper date format etc
> > as opposed to formatting it AFTER it generates.
> >
> > Thanks - your continued help is appreciated,
> > GillianHG
> >
> >
> > "Debra Dalgleish" wrote:
> >
> >
> >>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 ***
> >>>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
> >>
> >>
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>
.

Quantcast