Microsoft KB Archive/127129

= Microsoft Knowledge Base =

MXL5: Thousands Separator Set to None Uses Comma Instead
Last reviewed: September 12, 1996

Article ID: Q127129

The information in this article applies to:


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

This number format is added to the Format Codes list for the Number category.

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.