M
MrRJ
Hello,
In a pivot table, how can I convert a value of say 4,252,582 to $4.25M?
Thanks
MrRJ
In a pivot table, how can I convert a value of say 4,252,582 to $4.25M?
Thanks
MrRJ
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Eduardo
Hi,
go to the totals in the PV, right click on the mouse, value field settings,
left bottom corner choose number format
go to the totals in the PV, right click on the mouse, value field settings,
left bottom corner choose number format
M
MrRJ
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?
there, but what format can create what I would like to accomplish?
E
Eduardo
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
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
M
MrRJ
Thank you. That did the trick.
Eduardo said: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