Microsoft KB Archive/125331

Service Pack Setup Modifies [Intl] Section of WIN.INI

PSS ID Number: Q125331 Article last modified on 07-31-1995

2.00

WINDOWS

= SYMPTOMS =

After installing the Microsoft Access version 2.0 Service Pack, when you enter a value on your worksheet in Microsoft Excel and format the value with a format code that contains a comma (for a 1000 separator), the number appears truncated instead of being displayed with a comma as you expect. The Format Number dialog box may also truncate any formats at the point where the comma would appear.

= CAUSE =

This behavior occurs in Microsoft Excel when there is an incorrect 1000 Separator setting in the Microsoft Windows International dialog box. It has been reported that after installing the Service Pack, an unprintable character that may appear to be a comma is set for the sThousand entry in the [Intl] section of the WIN.INI file.

= RESOLUTION =

To work around this behavior, you must either modify the sThousand entry in your WIN.INI file or, if the entry does not appear, set the sThousands entry in the International tool in Control Panel.

To modify the WIN.INI file, follow these steps:

  Close Microsoft Excel if it is running.   Use any text editor, such as Notepad, to open the WIN.INI file.   Locate the [Intl] section of the file. Modify the sThousand entry so that it reads as follows: sThousand=, NOTE: Even if the character after the equal sign (=) appears to be a comma, delete it and type a comma. This ensures that the correct value is being used.   Save and then close the file.   Quit and then restart Microsoft Windows. 

If the sThousand entry does not appear in your WIN.INI file, follow these steps:


 * 1) Close Microsoft Excel if it is running.
 * 2) In Program Manager, double-click the Control Panel icon in the Main program group.
 * 3) Double-click the International icon.
 * 4) In the Number Format box, choose the Change button.
 * 5) In the 1000 Separator box, type a comma.
 * 6) Choose the OK button.
 * 7) Choose OK to close the International dialog box, and then close Control Panel.

= STATUS =

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

= REFERENCES =

For more information about the Microsoft Excel symptoms, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q125032 TITLE : Numbers with 1000 Separator Format Appear Incorrectly

For information about the Microsoft Access version 2.0 Service Pack, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q122927 TITLE : WX1124: Microsoft Access Version 2.0 Service Pack

Additional reference words: 2.00 jet25 jet 2.5 KBCategory: kbsetup KBSubcategory: StpGnrl

=
================================================================

Copyright Microsoft Corporation 1995.