Pivot - convert currency format
 

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

Thanks
MrRJ

Pivot - convert currency format
 

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

Pivot - convert currency format
 

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

Pivot - convert currency format
 

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

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