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
|