Pivot Table Default Number Format

Aeroed7

New Member
Joined
Feb 3, 2006
Messages
19
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
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,096,186
Messages
5,448,857
Members
405,534
Latest member
paddybear

This Week's Hot Topics

Top