Header cells that the drillthrough inserts are formatted using the Label Format format cell on the XLCubedFormats sheet. Data cells are formatted using the default cell format.
Additional formats specified in the XLCubedFormats sheet will also be applied. To do this, add a new row for each column that should be formatted:
- set the Dimension/Column cell to Column
- set the Member1 Name cell to the name of the drillthrough column to be formatted
- set the Data Format cell to the desired format
The column name can be set to the wildcard format. For example, *Date will format all columns ending in Date with the format. For example, you can format two columns differently: Date is set to date format, and Order Number to text.
