Browse

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

© 2008 freetechtips.com. All rights reserved.