XL2000: Two-Digit Year Displayed When You Type a Four-Digit Year

When you type a date that includes a four-digit year, Microsoft Excel only displays two digits for the year. This behavior occurs even if the Short date style setting (on the Date tab under Regional Settings in Control Panel) is set to display four-digit years.

This behavior may occur when the cell in which you type the date is formatted with the General number format.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To resolve this problem, add the EnableFourDigitYearDisplay entry to the Windows registry. To do this, follow these steps:

1. On the Start menu, click Run. In the Open box, type regedit. Click OK.
2. In the left pane, click the plus signs (+) to the left of the following items (in order):
   HKEY_CURRENT_USER
   Software
   Microsoft
   Office
   9.0
   Excel
3. In the left pane, click the Options folder.
4. On the Edit menu, point to New and then click DWORD Value.
5. Type EnableFourDigitYearDisplay, and then press ENTER.
6. Double-click the EnableFourDigitYearDisplay icon.
7. In the Value data box, type 1, and then click OK.

This change takes effect the next time that you start Excel.

NOTE: After you enable the EnableFourDigitYearDisplay registry entry, Excel always displays four digits when you type a date that includes a four-digit year. This may override your Short date style setting under Regional Settings in Control Panel.