Pivot Table Default

G

Guest

Every time I create a pivot table, I have to edit the number that I am
summing so that it is formatted as number with a comma. And often it will
default to counting instead of summing, so I have to edit that also. Is
there a way to have the default format for a number to have commas and to
default to sum not count?
 
D

Debra Dalgleish

You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.
When the field is added to the data area, it will be formatted as
General. There's no option where you can change that setting either.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of % in pivot table 1
Default values for cell formatting and Pivot tables 1
Pivot table - value field settings - default? 2
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Excel 2007 Pivot Table question 1
Pivot Table Default Setting 1
Pivot Data 2
Pivot Table - Cell Value 2

Top