Pivot Table Default

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top