Err Msg: "! Invalid Character Setting" in Expression Field

Last reviewed: February 5, 1998
Article ID: Q81059
The information in this article applies to:
  • Microsoft Word for Windows versions 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c, 6.0, 6.0a, 6.0c
  • Microsoft Word for Windows 95, versions 7.0, 7.0a
  • Microsoft Word for Windows NT, version 6.0
  • Microsoft Word 97 for Windows

SYMPTOMS

You receive the following error as the result of a Word Expression field:

   ! Invalid Character Setting

CAUSE

You specified an incorrect character as a decimal or list separator in Regional Settings (International in Windows 3.x) in the Windows Control Panel.

The characters you use for a list separator and decimal separator are set for all Windows-based applications under the Regional Settings or International icons in the Windows Control Panel. The characters used by default depend on the Country settings you select. Some characters are invalid as list or decimal separators. The invalid characters vary depending on the country setting. For example, when you set the Country to United States, any character other than a period is invalid as a decimal separator.

Note: This error may also occur as the result of an incorrect or blank Currency Format or Number Format setting.

RESOLUTION

To correct this problem, choose the appropriate method depending on which operating system you are using.

Windows 95, Windows NT 4.0

  1. On the Windows taskbar, click the Start button, point to Settings, and click Control Panel.

  2. Double-click the Regional Settings icon and then click the Number tab.

  3. In the Decimal Symbol box, type a valid character. For example, if the country is set to United States, type a period.

  4. In the List Separator box, type a valid character. For example, if the country is set to United States, type a comma.

  5. Click Apply.

  6. Click OK.

Windows 3.x, Windows for Workgroups 3.x, Windows NT 3.5x

  1. In Windows Program Manager, double-click the Main icon.

  2. Double-click the Control Panel.

  3. Double-click the International icon.

  4. In the List Separator box, type a valid character. For example, if the country is set to United States, type a comma.

  5. In the Number Format box, click the Change button. In the Decimal Separator box, type a valid character. For example, if the country is set to United States, type a period.

  6. Click OK.

  7. Click OK again.

REFERENCES

"Microsoft Windows User's Guide," version 3.0, pages 182, 186 "Microsoft Word for Windows User's Guide," version 2.0, pages 306-311, 749


KBCategory: kbusage
KBSubcategory: kbtable
Additional query words: 2.0 errmsg err msg calculate sum 6.0
6.0a winword 7.0 word95 6.0c winword2 calculation calculating
word7 word6 spreadsheet table results ntword wordnt word97 word8 8.0
Keywords : kbtable
Version : 2.x 6.0 6.0a 6.0c 7.0 7.0a
Platform : WINDOWS


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 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.