Microsoft KB Archive/184964

= Two-Digit Years Don't Follow Windows 98 Regional Settings =

Article ID: 184964

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Windows 98 Standard Edition

-



This article was previously published under Q184964



SYMPTOMS
In the versions of Microsoft Excel that are listed at the beginning of this article, if you enter a date that uses only two digits for the year, the date may appear to be incorrect.

For example, if you enter 1/1/50, the date may appear as 1/1/1950, not 1/1/2050.



CAUSE
This problem may occur when the following conditions are true:


 * You are running Microsoft Excel on a computer that is running Microsoft Windows 98.

-and-
 * You use the controls in the Date tab of the Regional Settings icon in Control Panel to change the date range that is used by two-digit years.

Specifically, this problem occurs because the versions of Microsoft Excel that are listed at the beginning of this article do not follow the two- digit year settings in the Date tab of the Regional Settings dialog box under Microsoft Windows 98.



RESOLUTION
To resolve this problem, use four digits for the year instead of two digits when you enter a date in a cell. For example, if you want to enter the date 1/1/2050, type "1/1/2050" (without the quotation marks) and press ENTER.

If you must use two-digit years, please see the following article in the Microsoft Knowledge Base for more information:

302768 : How Microsoft Excel works with two-digit year numbers



MORE INFORMATION
In Microsoft Windows 98, you can control the behavior of dates that use two-digit years by following these steps:


 * 1) On the Start menu, point to Settings, and then click Control Panel.
 * 2) Double-click Regional Settings. Then, click the Date tab.

Near the top of the dialog box, you see the following:

  When a two digit year is entered, interpret as a year between:

[ 1930 ] and  [ 2029 ]

The second date (2029) is in a control that allows you to specify a different year. If you change this value, the first date (1930) changes so that a one-hundred-year span is covered that between the two dates. When you click OK, programs that follow these settings change their behavior with respect to dates that use two-digit years.

However, the versions of Microsoft Excel that are listed at the beginning of this article do not follow these settings because they were released before Microsoft Windows 98. Each program uses different behavior.

Additional query words: XL97 XL5 XL7 5.0 7.0 year2000 y2k year 2000 calendar XL

Keywords: kbprb KB184964

-

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

© Microsoft Corporation. All rights reserved.