Pivot Tables

D

dipsy

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.
 
D

Dave Peterson

You can format those cells after you create the pivottable:

Select them
format|Cells|number tab|custom category
"#,##0,"

w/o the quote marks.
 
D

dipsy

Hi Dave:

Thanks so much - this did work - can you please tell me what it means?

Thanks.
 
Top