Pivot Formatting

M

Melvin Miller

How do I format currency data field values in a pivot
table using VBA? I tried
..PivotFields("Amount").NumberFormat = "$#,##0.00_);[Red]
($#,##0.00)"

but it didn't work.

I was wondering if there is a method/property I can use
that identifies the cells in targeted "date-named" columns.
 
Top