+ Reply to Thread
Results 1 to 3 of 3

Change Default Formatting of Pivot Drill-Down Data

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Change Default Formatting of Pivot Drill-Down Data

    Hello - I'm using Excel ver 2007 and have a pivot table that has both counts and %'s. When I double click for the detail behind the pivot, the number formats are all general. I just want only the % column to show as a % and leave the other two columns showing as they are. I've been all over the net looking for a solution and I'm hoping there is one. I need this to show upon double clicking and not have to manually reformat the drill down data each time. Is there a way to do this in 2007 or 2003?? Thanks!

  2. #2
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    Smile Re: Change Default Formatting of Pivot Drill-Down Data

    Please let me know if this works. If you are in excel 2007 click on your created pivot table from the menu bar select options-select entire pivot table- right click and format cells ... this should work.

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Change Default Formatting of Pivot Drill-Down Data

    Thanks! Unfortunately that didn't work. It changes the formatting of all number columns. The first 3 columns are text, then the next 2 oolumns need to be normal numbers. The last column has percentages. When I double click on any of the cells the source data shows all of the 3 columns with numbers as normal numbers and the percentages showing as 0.00 rather than 0.00%.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1