Works 2000: Space Does Not Appear After Numeric Data in a Cell or Field (239206)


The information in this article applies to:

  • Microsoft Works 2000
  • Microsoft Works Suite 2000
This article was previously published under Q239206

SYMPTOMS

When you type numeric data in a cell in your Microsoft Works 2000 Spreadsheet or in a field in your Works 2000 Database file, and you then press the SPACEBAR, this space may not appear after the numeric data.

For example, if you type 999 followed by a space, Works 2000 may not display the space that appears after the numeric data.

CAUSE

This behavior can occur if the space following the numeric data is the last entry in the cell or field.

NOTE: If the numeric data is followed by a space, and then more data, the space is sure to appear.

RESOLUTION

To work around this behavior, follow these steps (using the set appropriate to your operating system).

For Works 2000 Spreadsheet

  1. Start Works 2000 Spreadsheet.
  2. On the File menu, click Open.
  3. In the Open dialog box, browse to select your spreadsheet file, and then click Open.
  4. Select the cell that contains the numeric data.
  5. On the Format menu, click Number.
  6. On the Number tab, click Text in the format pane.
  7. Click the Alignment tab.
  8. Click Left in the horizontal pane, and then click OK.
  9. Retype the numeric data in the selected cell, press the SPACEBAR, and then press ENTER.

For Works 2000 Database

  1. Start Works 2000 Database.
  2. Click Add in the Create Database dialog box, and then click Done.
  3. On the File menu, click Open.
  4. In the Open dialog box, browse to select your database file, and then click Open.
  5. Select the field that contains the numeric data.
  6. On the Format menu, click Field.
  7. On the Field tab, click Text in the format pane.
  8. Click the Alignment tab.
  9. Click Left in the horizontal pane, and then click OK.
  10. Retype the numeric data in the selected cell, press the SPACEBAR, and then press ENTER.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbpending KB239206
©2004 Microsoft Corporation. All rights reserved.