Pivot Table Defaults

[Jonbob]

Does anyone know how I can set-up excel so everytime I create a new pivot table the formatting is always set to show numbers as Number format comma separated and zero decimal places.

 

[BrianB]

I believe that pivot tables use the "Normal" style. You can therfore change the defaults via menu Format/Style.