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