Microsoft KB Archive/77711

= Entering or Sorting Names That Resemble Dates =

Article ID: 77711

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition

-



This article was previously published under Q77711



SUMMARY
If data that resembles the name of a month is entered into a field, Works will assume that this is the name of a month and modify the data accordingly. For example, the names April, Marc, and June may be abbreviated to Mar, Apr, and Jun, or names like Marc and Jan may be automatically expanded to March and January.

This is by design, Works makes some assumptions to make the program faster and easier to use, and sometimes the assumption may be wrong.



WORKAROUND
Enter these names as text, by starting the entry with a quotation mark (&quot;) (for example, &quot;Marc).

Sort Problem
A more subtle manifestation of this problem is that this data is perceived by the system as a date, and sorts differently than text. For example, &quot;Bocephus&quot; appears before &quot;April&quot; when sorted.



RESOLUTION
Reenter the data as text.

Keywords: KB77711

-

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

© Microsoft Corporation. All rights reserved.