ExcelBanter - Pivot table number format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Pivot table number format (https://www.excelbanter.com/excel-programming/301090-pivot-table-number-format.html)

JIM.H.[_2_]

Pivot table number format

Hello,
I create the pivot table through a macro and I need the
format all the numbers with currency, how can I do that?
The data range is not fixed each time I run macro.
Thanks,
Jim.

All times are GMT +1. The time now is 12:09 AM.