Service Pack Setup Modifies [Intl] Section of WIN.INI
  
PSS ID Number: Q125331
Article last modified on 07-31-1995
 
2.00
 
WINDOWS
 

---------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Access version 2.0
---------------------------------------------------------------------
 
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:
 
1. Close Microsoft Excel if it is running.
 
2. Use any text editor, such as Notepad, to open the WIN.INI file.
 
3. 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.
 
4. Save and then close the file.
 
5. 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.
