Microsoft KB Archive/148216

= Works: Current Year Entered in Cells with Month/Year Formatting =

Article ID: 148216

Article Last Modified on 11/15/2004

-

APPLIES TO


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

-



This article was previously published under Q148216



SUMMARY
Cells or fields formatted as Month/Year in a Spreadsheet or Database will automatically insert the current year when the second part of the date can be considered a day of the month. For example, if the current year is 1996, and you enter 10/30 into a cell, the date will be displayed as 10/96. This occurs even if you meant October, 1930.



MORE INFORMATION
To ensure the correct year is displayed, remember the following rule:

If the year could also be a day of the month, enter the complete year date. For example, if you want to enter October, 1930 into a cell formatted as Month/Year, enter 10/1930. The date will then be displayed correctly as 10/30.

The valid date range in Works is 1/1/1900 to 6/3/2079. Any date outside this range will be treated as text.

Additional query words: 2.00 3.00 4.00 4.00a 4.50 4.50a w_works dates wrong changed incorrect

Keywords: kbinfo kbprb KB148216

-

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

© Microsoft Corporation. All rights reserved.