Pivot Tables
I have a data table with full numbers. Now I want to create a Pivot table
with numbers in 000's. So data table will have $1,000,000 but in Pivot table I want to show - $1,000. Thanks in advance for your help. |
You can format those cells after you create the pivottable:
Select them format|Cells|number tab|custom category "#,##0," w/o the quote marks. dipsy wrote: I have a data table with full numbers. Now I want to create a Pivot table with numbers in 000's. So data table will have $1,000,000 but in Pivot table I want to show - $1,000. Thanks in advance for your help. -- Dave Peterson |
Hi Dave:
Thanks so much - this did work - can you please tell me what it means? Thanks. "Dave Peterson" wrote: You can format those cells after you create the pivottable: Select them format|Cells|number tab|custom category "#,##0," w/o the quote marks. dipsy wrote: I have a data table with full numbers. Now I want to create a Pivot table with numbers in 000's. So data table will have $1,000,000 but in Pivot table I want to show - $1,000. Thanks in advance for your help. -- Dave Peterson |
All times are GMT +1. The time now is 03:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com