Works: Person's Name Is Changed to the Name of a Month (195977)


The information in this article applies to:

  • Microsoft Works 6
  • Microsoft Works 2000
  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q195977

SYMPTOMS

When you type a person's name in a Works for Windows database field or spreadsheet cell, the name may be changed automatically to the name of a month or the abbreviation for a month. You may experience this behavior with the following names:

  • Marc
  • April
  • May
  • June

CAUSE

This behavior can occur because Works attempts to increase the speed and ease of use when you enter text in these modules. When you type any of these names, Works assumes you want to enter the name of a month rather than an individual's name.

RESOLUTION

To resolve this issue, type a QUOTATION MARK (") in front of the name. For example, if you want to type the name "Jan," type the following line:

"Jan

To prevent this issue from occuring, format the field or cell as text. To do this, use the appropriate method for the Works module you are using.

Database

  1. Open the Works database you want to use.
  2. Click the field in which you want to type the name.
  3. On the Format menu, click Field.

    NOTE: If you are using Works 3.0, click Number on the Format menu.
  4. Under Format, click Text, and then click OK.

Spreadsheet

  1. Open the Works spreadsheet you want to use.
  2. Click the cell or column in which you want to type the name.
  3. On the Format menu, click Number.
  4. Under Format, click Text, and then click OK.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbprb kbui KB195977
©2004 Microsoft Corporation. All rights reserved.