Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Scaling Pivot numbers (Excel2003)

    I want to change a Pivot table report presentation to show amounts in thousands, such as 1.375 for 1,375,000. Do I have to add columns to the table to do the scaling and use those instead of the actual numbers? I looked at the number formatting dialog but I cannot go below 0 for decimal places. Thanks.

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

    Re: Scaling Pivot numbers (Excel2003)

    Set the number format to the custom format <code>0,</code> (that is a zero followed by a comma). Similarly, if you want to display amounts in millions, use <code>0,,</code> (a zero followed by two commas).

Posting Permissions

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