Microsoft Knowledge Base

• Microsoft Excel for the Macintosh, version 5.0

SYMPTOMS

If you use the Numbers control panel on the Macintosh to change the Thousands separator value to None, Microsoft Excel still uses the comma for the thousands separator in number formats.

CAUSE

This behavior occurs because when you set the Thousands separator value to None, Microsoft Excel does not recognize this as a valid separator, and uses the comma character as the "default" character.

WORKAROUND

To set the thousands separator to none in Microsoft Excel, create a custom number format that does not use a thousands separator. To do this, use the following steps:

1. From the Format menu, choose Cells.

2. In the Format Cells dialog box, select the Number tab.

3. In the code box, type the desired number format, for example "####.0" (without the quotation marks) and choose OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

For more information about Number Format Codes, choose the Search button in Help and type:

   number formats, codes for