This article discusses the Microsoft SQL Server Analysis Services formats that are supported by cube formulas in Excel Services in SharePoint Server 2007.

Supported Analysis Services formats

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.
Cube formulas in Excel Services in SharePoint Server 2007 support the following Analysis Services formats:

• Standard
• Currency
• Short Date
• Percent

Unsupported Analysis Services formats

Cube formulas in Excel Services in SharePoint Server 2007 do not specifically support the following Analysis Services formats:

• Custom Analysis Services Formats
• #
• #,#
• #,#.0
• #,#.00 (For example, 123,456.78 is displayed as 123456.78)
• Short Time (For example, 12/11/2006 at 10:37 is displayed as 39065.4429)

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.