Works: Current Year Entered in Cells with Month/Year Formatting (148216)
The information in this article applies to:
- Microsoft Works 2.0
- Microsoft Works 3.0
- 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 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.
| Modification Type: | Major | Last Reviewed: | 11/15/2004 |
|---|
| Keywords: | kbinfo kbprb KB148216 |
|---|
|