XL: Unexpected Number Formats Appear Under Custom Category

• Microsoft Excel for Windows, versions 4.0, 5.0, 5.0c
• Microsoft Excel for the Macintosh, version 4.0, 5.0, 5.0a
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows

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 

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