Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Unexpected Number Formats Appear Under Custom Category


View products that this article applies to.

This article was previously published under Q214004

↑ Back to the top


Summary

When you click the Increase Decimal button on the Formatting toolbar, new number formats are created that appear on the Number tab of the Format Cells dialog box. (To open this dialog box, click Cells on the Format menu.)

↑ Back to the top


More information

These new number formats correspond to the number of decimal places added: one custom number format is added for each decimal place that you add to the number when you click the Increase Decimal button. The new number formats are visible when you click Custom in the Category list on the Number tab of the Format Cells dialog box.

These number formats remain, even when you click the Decrease Decimal button on the Formatting toolbar.

↑ Back to the top


References

For more information about custom number formats, click Microsoft Excel Help on the Help menu, type custom number formats in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top


Keywords: KB214004, kbhowto

↑ Back to the top

Article Info
Article ID : 214004
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 283