Pivot Table Detail

[sfisher]

Good Morning,
I have a quick question. Is it possible to control the formatting of the detail of a pivot table.

 

[cherria]

Yes...

Right click on the field button for the detail (the one that says sum of... or count of...)

then select field settings and click the number button

 

[sfisher]

Thanks for your reply, however; I must not have been clear.
Once you pivot the data and you double click on the Summary data in the pivot, it creates a new tab with the records that are used to create the roll-up data that you doubleclicked on. It is this new tab that is being generated that I would like to have some control over the formatting.

Thanks!

God that sounds confusing, I hope someone can make it out.