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

• Microsoft Office Spreadsheet Component 9.0, run time
• Microsoft Excel 2000

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:

Q216578 XL2000: Calculation Differences with the Office Spreadsheet

Additional query words: XL2000

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb