Microsoft KB Archive/242405

= Works 2000: Current Year Is Displayed in Cells Formatted As Month/Year =

Article ID: 242405

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works Suite 2000

-



This article was previously published under Q242405



SUMMARY
Cells or fields formatted as Month/Year in a Works spreadsheet or database automatically insert the current year when the second part of the date can also be considered a day of the month.

For example, if you type 4/30 into a cell or field, the date is displayed as 4/, even if the correct year is April, 1930.



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

If the year could also be a day of the month, type the complete year in the cell or field. For example, if you want to type April, 1930 into a cell formatted as Month/Year, type 4/1930. The date is then displayed correctly as 4/30.

NOTE: The valid date range in Works 2000 is 1/1/1900 to 6/3/2079. Any date outside of this range is treated as text.

Additional query words: w_works works2000 wks2k dates correctly improper

Keywords: kbinfo kbui KB242405

-

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

© Microsoft Corporation. All rights reserved.