Microsoft KB Archive/928727

= Description of the Analysis Services formats that are supported by cube formulas in Excel Services in SharePoint Server 2007 =

Article ID: 928727

Article Last Modified on 5/14/2007

-

APPLIES TO


 * Microsoft Office SharePoint Server 2007

-



INTRODUCTION
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)
 * #,#.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.

Additional query words: sharepointserver2007 sharepointserver2k7 sharepointserver12 sps2007 sps2k7 sps12 moss2007 moss2k7 moss12 xlservices excelservices ecs ewa AS

Keywords: kbexpertiseinter kbhowto kbinfo KB928727

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.