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

 
Template design by venus soft
Copyright © 2008 Venus Soft