Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Default
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Default
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. Mike H. wrote: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Default - Count to Sum | Excel Discussion (Misc queries) | |||
pivot table field summarize default | Excel Worksheet Functions | |||
Pivot table - default answer | Excel Discussion (Misc queries) | |||
Pivot Table: I want default to be sum & not count | Excel Worksheet Functions | |||
Pivot Table - Default Settings for Table Options | Excel Discussion (Misc queries) |