Microsoft KB Archive/124276

= Unexpected Number Formats Appear Under Custom Category =

Article ID: 124276

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q124276





SUMMARY
When you use 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 you add to the number when you click the Increase Decimal toolbar button. The new number formats are visible when you click either Number or Custom in the Category list on the Number tab of the Format Cells dialog box.

NOTE: In Microsoft Excel version 7.0 and later, the custom number formats that are created are visible only when you click Custom in the Category list on the Number tab. When you click Number in the Category list, the Decimal Places value is set to the current number of digits to the right of the decimal point in the active cell.

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

NOTE: In Microsoft Excel version 4.0, the Number Format dialog box is accessed by clicking Number on the Format menu.

