Pivot Tables

[Guest]

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.

 

[Guest]

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?