+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Drill Down Number Formatting

  1. #1
    Gregg Riemer
    Guest

    Pivot Table Drill Down Number Formatting

    When you double-click a cell in the data area or a pivot table, Excel places
    the detail data summarized in the cell on a new worksheet.

    Unfortunately, the number formatting on the new worksheet doesn't seem to
    follow the formatting of the source data. I can use the Format, Style,
    Number to make the formatting the same for each numeric field, but I don't
    want the same format for each numeric field. For example, I want some of the
    columns to be comma with 3 decimal places and others to have no decimal
    places just like they are in the source data for the pivot table.

    Any suggestions?

  2. #2
    Debra Dalgleish
    Guest

    Re: Pivot Table Drill Down Number Formatting

    You can use the Format Painter button on the toolbar, to copy the
    formatting from the source data, and apply it to the detail sheet.

    Do this manually, or record a macro, then run the macro as required.

    Gregg Riemer wrote:
    > When you double-click a cell in the data area or a pivot table, Excel places
    > the detail data summarized in the cell on a new worksheet.
    >
    > Unfortunately, the number formatting on the new worksheet doesn't seem to
    > follow the formatting of the source data. I can use the Format, Style,
    > Number to make the formatting the same for each numeric field, but I don't
    > want the same format for each numeric field. For example, I want some of the
    > columns to be comma with 3 decimal places and others to have no decimal
    > places just like they are in the source data for the pivot table.
    >
    > Any suggestions?



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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