MacXL: Unexpected Number Formats Appear Under Custom Category

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.)

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.

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: