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