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:
- Start Regedit
- Go to HKEY_USERS \ .DEFAULT \ Software \ Policies \ Microsoft \ Office \ 9.0 \ Excel \ Options
- Add or Change the DWORD Value EnableFourDigitYearDisplay to 1
Note: You may need to create the Excel and Options keys
No comments:
Post a Comment