XL: "List and Decimal Separators Are Identical" Error

• Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0, 5.0a
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

When you start Microsoft Excel, you may receive the following error message:

   The list and decimal separators specified by the system are identical.
   Substituting ';' for the list separator.

   Error in formula

CAUSE

This behavior occurs if you change the Decimal Separator to a comma (,) character in:

• the Numbers control panel in System 7.1
• the Regional Settings control panel in Microsoft Windows 95

      -or-
  

• the International control panel in Microsoft Windows.

Note that you may also receive this error message if your Macintosh System file is damaged.

If you use a comma in a formula on your worksheet after receiving the "List and decimal separators are identical" error message described above, you may receive the following error message

   Error in formula

Note that in Microsoft Excel, the Module General tab in the Options dialog box displays the comma character as the default setting for the List Separator value. You cannot change this value in the Options dialog box.

WORKAROUNDS

To avoid receiving this error message in Microsoft Excel for the Macintosh, use the Numbers control panel to select any of the following Number Format options:

   U.S.
   Australian
   British
   any of the Swiss formats

   NOTE: If you receive the error message when you start Microsoft Excel
         for the Macintosh with any of the formats listed above except for
         the British format, your System file may be damaged.

• the Regional Settings control panel in Microsoft Windows 95

      -or-
  

• the International control panel in Microsoft Windows

What to Do if You Have a Damaged Macintosh System File

If you have determined that the System file may be damaged, do the following:

1. Start your computer using your Disk Tools disk.

2. Move your System file from the System Folder on the hard drive to the Desktop.

3. After moving this file, copy the System file from the System Folder on the Disk Tools disk to the System folder on the hard drive.

4. Open and then close the System Folder on your hard drive. This confirms with your Macintosh that the System is still valid in this folder.

5. Eject the Disk Tools disk, and restart your computer.

6. Start Microsoft Excel.

MORE INFORMATION

The Macintosh System software uses three different number separator values: List, Decimal, and Thousands. These values are set in a resource item (INTL) in the System file. In System versions earlier than version 7.1, the only way to change any of these number format values is to modify the resource in the System file using a program such as ResEdit. This is also true for Date and Time Formats. Note, however, that manually editing resources is NOT recommended.

In Macintosh System version 7.1, you can use the Numbers control panel to change the Decimal Separator, and the Thousands Separator values. However, if you change the Decimal Separator value to a comma (,) character, you receive the error message described above when you start Microsoft Excel.