XL: "List and Decimal Separators Are Identical" Error

Last reviewed: February 2, 1998
Article ID: Q128001
The information in this article applies to:
  • 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.

Additionally, after you receive this error message, you may receive the following error message when you enter a formula on your worksheet:

   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.

This behavior occurs because Microsoft Excel uses the comma character as the list separator by default. If you change the Decimal Separator to a comma character, this error message occurs because the Decimal Separator is the same as the List Separator.

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

This error message occurs because Microsoft Excel is using the semicolon character (;) as the new list separator and does not recognize the comma character in the 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.

To avoid receiving this error message in Microsoft Excel for Windows or Microsoft Excel for Windows 95, change the list separator to a character other than a comma, for example, a period in either:
  • 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.

This process will determine if the old System file has a damaged resource. If the test is successful, and Microsoft Excel starts without an error message, open the System file that you moved to the Desktop, and copy the contents into the new System file in the System folder.

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.


Additional query words: 3.00 4.00 5.00 5.00a
Keywords : kbenv kberrmsg kbprint
Version : WINDOWS: 2.x, 3.x, 4.0, 5.0, 5.0a, 7.0; MACINTOSH: 3.0, 4.0, 5.0
Platform : MACINTOSH WINDOWS
Issue type : kbbug kbref
Solution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.