Pivot - convert currency format

[MrRJ]

Hello,
In a pivot table, how can I convert a value of say 4,252,582 to $4.25M?

Thanks
MrRJ

 

[Eduardo]

Hi,
go to the totals in the PV, right click on the mouse, value field settings,
left bottom corner choose number format

 

[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?

 

[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

 

[MrRJ]

Thank you. That did the trick.

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