I've created a custom style...
Style currencyFormat = wb.Styles[wb.Styles.Add()];
currencyFormat.Custom = "$#,##0.0000";
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?