Pivot Table Default Number Format

[Aeroed7]

Hello,

Everytime I create a pivot table, the numbers are formatted the same way and I have to change them every time. Is there a way to change the default number format so I do not have to change it every time I create a new pivot table?

Thank you,

Ed

 

[ExcelDane]

As far as I know, there is no way to create a default number format which will apply to all new pivot tables.
However, this post contains useful tips on formatting existing tables and preventing formats from being lost when updating the table:

How to keep the Custom Number Format in my Excel Pivot Table

 

[cyrilbrd]

vba approach.