Unexpected Number Formats Appear Under Custom Category (124276)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
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.
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.
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | kbinfo kbualink97 KB124276 |
|---|
|