| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a Pivot Table into a Flat File format? | Excel Discussion (Misc queries) | |||
| Convert currency to $X.XMM | Excel Discussion (Misc queries) | |||
| add time and convert it to currency | Excel Worksheet Functions | |||
| convert a numerical currency into word format | Excel Worksheet Functions | |||
| CONVERT DATA TO CURRENCY FORMAT | Excel Discussion (Misc queries) | |||
Linear Mode
