Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how change Pivot Table default number format

Status
Not open for further replies.
Jaffey

Jaffey

Technical User
Jul 18, 2006
72
CA
I have to create pivot tables on a constant basis. The default number format is General. I am forever manually chainging it to Number with no decimal places and including a thousands seperator. Is there a way to make that the default?
 
Sort by date Sort by votes



Hi,

Can't see where there is a way to change the default.

Record a macro to change the format(s) and run it in the Worksheet_Calculate event, for instance.

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
740
mintjulep
M
arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
302
arvarr
arvarr
remeng
  • Locked
  • Helpful tip
Calculate Week Number - Week in Month - Holidays
Replies
0
Views
377
remeng
remeng
K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
686
combo
combo
arvarr
  • Locked
  • Question
Pivot Table drill through in a new workbook
Replies
3
Views
432
arvarr
arvarr

Part and Inventory Search

Sponsor

Back
Top