Article ID: 123194 - View products that this article applies to.
This article was previously published under Q123194
This article has been archived. It is offered "as is" and will no longer be updated.
In Microsoft Excel, when you enter a formula in a cell on a worksheet, the formula may return an incorrect value, or you may receive the following error message:
Error in formula
This behavior occurs if the character that you use to separate values in your formula is different from the character that is entered as the list separator in the International dialog box in Microsoft Windows. For example, if you use a comma to separate values in your formula, and the list separator is set to a hyphen (-) character, you receive the error message above when you enter the formula on the worksheet.
To work around this problem, use either of the following methods.
Method 1: Use a List Separator from the International Dialog BoxWhen you enter a formula on a worksheet in Microsoft Excel, use the list separator character that is set in the International dialog box in the Control Panel.
Method 2: Change the List Separator in WindowsIn Windows 3.x:
The list and decimal separators specified by the system are identical. Substituting ';' for the list separator.
Article ID: 123194 - Last Review: January 11, 2015 - Revision: 1.1