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?
--
Regards,
Ron
"dipsy" wrote:
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.
|