Microsoft KB Archive/239324

= Works 2000: Entire Cell Is Replaced by Asterisks When Replacing a Question Mark =

Article ID: 239324

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works Suite 2000

-



This article was previously published under Q239324



SYMPTOMS
When you click Replace on the Edit menu of your Microsoft Works 2000 Spreadsheet or Works 2000 Database file, and then attempt to replace a question mark (?) with an asterisk (*), Works 2000 replaces each non-question mark character with one asterisk, and each question mark character with two asterisks.

For example, if one of the cells contains the following:

Hello?

when you attempt to replace the question mark with an asterisk, Works 2000 does the following:





RESOLUTION
To work around this behavior, you need to manually replace the question mark with an asterisk. To do this, follow these steps:

Steps to Follow for Works 2000 Spreadsheet

 * 1) Start the Works 2000 Spreadsheet.
 * 2) On the File menu, click Open.
 * 3) In the Open dialog box, browse and select your spreadsheet file, and then click Open.
 * 4) On the Edit menu, click Find.
 * 5) In the Find dialog box, type ? in the Find what box, and then click OK.
 * 6) When Works 2000 finds the question mark, type * in the cell to manually replace the it.
 * 7) Repeat steps 4-6 until all the question marks are replaced with asterisks.

Steps to Follow for Works 2000 Database

 * 1) Start the 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 and select your database file, and then click Open.
 * 5) On the Edit menu, click Find.
 * 6) In the Find dialog box, type ? in the Find what box, and then click OK.
 * 7) When Works 2000 finds the question mark, type * in the cell to manually replace the it.
 * 8) Repeat steps 5-7 until all the question marks are replaced with asterisks.

Additional query words: w_works works2k

Keywords: kbaddin kbpending kbprb KB239324

-

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

© Microsoft Corporation. All rights reserved.