XL: Unexpected Number Formats Appear Under Custom Category

ID: Q124276

The information in this article applies to:

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 access 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 use 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 use 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.


REFERENCES

For more information about custom number formats, click Contents And Index on the Help menu, click the Index tab in Excel 97 Help, type the following text 


   numbers, formatting


and then double-click the selected text to go to the "Custom number, date, and time format codes" topic. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: 5.00a 5.00c 7.00a 97 XL97 XL5 XL4 


Keywords          : kbualink97 kbdta xlui xlformat 
Version           : WINDOWS:4.0,5.0,5.0c,7.0,7.0a,97; MACINTOSH:4.0,5.0,5.0a
Platform          : MACINTOSH WINDOWS 
Issue type        : kbinfo

Last Reviewed: April 22, 1999