Knowledge Base

MacXL: Unexpected Number Formats Appear Under Custom Category

Article ID: 192221

Article Last Modified on 1/23/2007

Microsoft Excel 2001 for Mac
Microsoft Excel 98 for Macintosh

This article was previously published under Q192221

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 you add to the number when you click the Increase Decimal toolbar 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 toolbar button on the Formatting toolbar.

REFERENCES

Excel 98

For more information about deleting unwanted custom number formats, click the Office Assistant, type number formats, click Search, and then click Delete a custom number format to view the topic.

NOTE: If the Assistant is hidden, click the Office Assistant button on the standard toolbar. If Microsoft Help is not installed on your computer, click the following article number to view the article in the Microsoft Knowledge Base:

179216 OFF98: How to Use the Microsoft Office Installer Program

Additional query words: XL98 XL2001

Keywords: kbinfo KB192221