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. |
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. |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com