XL2000: Unexpected Number Formats Appear Under Custom Category (214004)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q214004

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.)

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.

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.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbhowto KB214004
©2003 Microsoft Corporation. All rights reserved.