Microsoft KB Archive/232854

= XL2000: Custom Number Format Doesn't Appear in Property Toolbox =

Article ID: 232854

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Office Spreadsheet Component 9.0, run time

-



This article was previously published under Q232854



SYMPTOMS
When you open a Web page that contains a Microsoft Office Spreadsheet Component, either of the following symptoms may occur:
 * The Number format box in the Spreadsheet Property Toolbox may be blank.

-or-


 * When you change the number format of a cell, the previous number format that was in the cell does not appear in the Number format list.



CAUSE
This behavior occurs when you format a cell to use a custom number format and then publish the worksheet from Microsoft Excel. When you publish the worksheet, the Office Spreadsheet Component uses the custom number format for the cell. However, if you change the number format, the original custom number format will not appear in the Number format list. The Office Spreadsheet Component does not allow the creation of custom number formats.



MORE INFORMATION
For additional information about differences between the Office Spreadsheet Component and Excel, please see the following article in the Microsoft Knowledge Base:

216578 XL2000: Calculation Differences with the Office Spreadsheet

Additional query words: XL2000

Keywords: kbprb KB232854

-

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

© Microsoft Corporation. All rights reserved.