Microsoft KB Archive/239206

= Works 2000: Space Does Not Appear After Numeric Data in a Cell or Field =

Article ID: 239206

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * 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.

Additional query words: kbimu works2K w_works

Keywords: kbbug kbpending KB239206

-

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

© Microsoft Corporation. All rights reserved.