Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Tables
Hi - I need help to format pivot table data.
The data file has actual numbers example - $1,000,000 But in Pivot Table I want the numbers to be in 000's - $1,000. Is there a way to do that without changing the original data table? Thanks. |
#2
|
|||
|
|||
Try this:
1)Right-click the column heading of the numbers to be changed. 2)Select Field Settings from the shortcut menu 3)Click the [Number....] button Category: Custom Type: Select the format resembles what you want and put a comma immediately in front of the decimal points (or where the decimal points would be). Example: Change this: $#,##0_);($#,##0) To this: $#,##0,_);($#,##0,) Click [OK] Note: Doing that will hide make 1000000 display as $1,000 without actually changing the values. Is that what you want to do? -- Regards, Ron "dipsy" wrote: Hi - I need help to format pivot table data. The data file has actual numbers example - $1,000,000 But in Pivot Table I want the numbers to be in 000's - $1,000. Is there a way to do that without changing the original data table? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |