Pivot - convert currency format
Thank you. That did the trick.
"Eduardo" wrote:
Hi,
In format go to custom and enter
0.000,, "M"
The "0" means the decimals that will show up, just add or delete it
according to your needs
"MrRJ" wrote:
Can you please be more specific? If you are in the format screen, I can get
there, but what format can create what I would like to accomplish?
"Eduardo" wrote:
Hi,
go to the totals in the PV, right click on the mouse, value field settings,
left bottom corner choose number format
"MrRJ" wrote:
Hello,
In a pivot table, how can I convert a value of say 4,252,582 to $4.25M?
Thanks
MrRJ
|