This article discusses the Microsoft SQL Server Analysis Services formats that are supported by cube formulas in Excel Services in SharePoint Server 2007.
If a cell in a workbook has no defined number format, the number format is set to the Analysis Services format. This is true if the Analysis Services format is supported. If a cell in a workbook has a defined number format, the cell number format takes precedence over the Analysis Services format. This is true if the Analysis Services format is supported. The cell number format is applied, and the Analysis Services format is disregarded.
Note If no specific number formats have been applied to the cell, the general number format will be applied. The workbook author can still use a specific number format, date format, or percentage format on the cells that contain cube formulas to override these format selections.