I am trying to format a PivotTable using VBA and am having a few problems.

1. When I "drill-down" on a Row field, I get a "XXXX Total" line appearing. Is there anyway I can stop this ie. I don't want a line being inserted as I'm not interested in the (sub-)total?

2. When the new column (ie. 'Row Field') appears (having double clicked on the previous Row field), how can I format it as "X,XX0.00"? The NumberFormat property only applies to Data fields (not Row or Column fields) and using 'Columns.Format' doesn't help either as I hide the Row field before any drill-downs are initiated. Is there another way?