Works: Blank 1000 Separator Causes Errors

Article translations Article translations
Article ID: 97747 - View products that this article applies to.
This article was previously published under Q97747
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all


If the International Number Format in the International Settings in the Windows Control Panel is changed so that the 1000 Separator box is blank, Works for Windows generates the following errors:

  1. You will get the error message: "Number not valid" when you enter a field width or height greater than zero in the Database form view.
  2. The Spreadsheet Fill Series command will fill in random numbers.
  3. In the Spreadsheet, the separator may be a period or a vertical line.


To correct this problem, make the following change:

  1. From the Windows Control Panel, choose International.
  2. In the Number Format box, choose Change.
  3. Enter the character that you'd like to separate thousands with (such as a comma [,]).
Additional references: 2.0 2.0a separates separating down across size list square dark wrong incorrect heighth


Article ID: 97747 - Last Review: October 21, 2013 - Revision: 3.0
  • Microsoft Works 2.0 Standard Edition
  • Microsoft Works 2.0a
kbnosurvey kbarchive KB97747

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from