Having Excel 2000 Display the Year with Four Digits
Normally, if you enter 1999 or 2000 as the years in Excel, it will change it to 99 or 00.
To change Excel 2000 so it shows a four digit year:
1. Start Regedit
2. Go to HKEY_USERS \ .DEFAULT \ Software \ Policies \ Microsoft \ Office \ 9.0 \ Excel \ Options
3. Add or Change the DWORD Value EnableFourDigitYearDisplay to 1
Note: You may need to create the Excel and Options keys