View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MrRJ MrRJ is offline
external usenet poster
 
Posts: 109
Default 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