Knowledge Base

Works: Numbers Appear as Text in Spreadsheet or Database

Article ID: 134945

Article Last Modified on 1/19/2007

APPLIES TO

This article was previously published under Q134945

SYMPTOMS

Numbers with decimal points in a spreadsheet or a database may look like or be treated as text by Microsoft Works. This can affect formulas, sorts, or queries. In Works 4.0 or later, you may receive the following error message:
The list separator and decimal separator characters are the same and must be different.

Works will use the . character for the list separator. You can change the separator in the Windows Control Panel under Regional Settings, if desired.

CAUSE

This behavior occurs when the Decimal Separator in the International tool (Microsoft Windows 3.x) or the Regional Settings tool (Microsoft Windows 95 or later) in Control Panel is set to a comma (,) instead of a period (.).

RESOLUTION

To resolve this issue, change the Decimal Separator to a period. To do this, use the appropriate method for your version of Windows.

Windows 95 or Later

  1. Click Start, point to Settings, and then click Control Panel.
  2. Double-click Regional Settings.
  3. Click the Number tab.
  4. Change the Decimal Symbol to a period (.) and click OK.

Windows 3.x

  1. Open the Control Panel, usually located in the Main program group.
  2. Double-click International Settings.
  3. In the Number Format section, click Change.
  4. Change the Decimal Separator to a period (.) and click OK.
  5. Click OK and close the Control Panel.

Additional query words: 2.00 3.00 4.00 4.00a 4.50 w_works works2k works6 quotes string

Keywords: kbenv kberrmsg kbprb KB134945


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.