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