Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Row/Column | Excel Discussion (Misc queries) | |||
Date Selection for Pivot Table | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |