And I don't have any problems applying this to a data sheet range or cell but I need to apply it to a pivot table column. I hoped that the pivot table column would inherit the style of the underlying column but that is not the case. How do I apply this style to a my pivot column?
We will support Custom formattings for pivot fields data soon. Currenlty you may only apply standard Number formats using....pivotField.Number property.