Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting Pivot Tables (Excel XP)

    Is there a way to automatically set the Pivot Table Options to always Sum a field by default, instead of Count? Also, is there a way to automatically set all Pivot Tables to format numbers with a comma, 2 decimal places? After researching this web site I believe the answer is No to both questions. Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting Pivot Tables (Excel XP)

    If you drag a field to the Data area of a pivot table, the default function is Sum for numeric fields, and Count for text fields. There is no way to change this default, as far as I know.

    The default format for cells in the data area will be that of the Normal style, so if you set Normal to display numbers with two decimal places and comma as thousands separator, a new Pivot table will use that.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re:Thank you

    Thank you.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Pivot Tables (Excel XP)

    I changed the default spreadsheet in the XLSTART directory. That allowed me to change the Normal style to always have a comma with 0 decimals.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •