Microsoft KB Archive/91689

= Works Error:&quot;Operator Missing...&quot; or &quot;Formula contains an error&quot; =

Article ID: 91689

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft Money 2000 Business & Personal Edition

-



This article was previously published under Q91689



SUMMARY
If the Windows list separator is set to a character other than a comma, functions you enter in the Works Spreadsheet or Database may produce one of the following error messages.

In Works 2.0 or 3.0
Operator Missing or Not Valid

In Works 4.0, 4.5, and 4.5a for Windows 95
The formula contains an error. Click OK to return to the formula and correct it.



MORE INFORMATION
This error message occurs even if the function is entered correctly. To change the list separator in Windows 3.1, do the following:


 * 1) From the Main group in Program Manager, click Control Panel.
 * 2) Choose the International icon.
 * 3) Select the List Separator field and enter a comma.
 * 4) Choose OK.

In Windows 3.0, changing the list separator from the Windows Control Panel does not change it permanently. To change the list separator in Windows 3.0, do the following:

 Open Win.ini in Notepad or another text editor. In the [intl] section, locate sList= Change the sList= entry to a comma. For example:

sList=,

 Save the changes to Win.ini.

You can also use this method in Windows 3.1.

Additional query words: 2.00 2.00a 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a ss ErrMsg db w_works

Keywords: kbinfo KB91689

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.