Article ID: 214004 - Last Review: September 27, 2003 - Revision: 3.1 XL2000: Unexpected Number Formats Appear Under Custom CategoryThis 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. REFERENCESFor 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.
| Article Translations
|
Back to the top
