Enable Four Digit Year in Microsoft Excel 2000 (All Windows)

When Excel formats a date, it uses one of several default formats, the most common is the system short date (yy). Therefore when a user types a 4-digit year (yyyy) date in Excel, it may be displayed in a 2-digit year (yy) format. This tweak changes to default the 4-digit format.

This tweak can be easily applied using WinGuides Tweak Manager. Download a free trial now!

Open your registry and find the key below.

Create a new DWORD value named "EnableFourDigitYearDisplay" and set it to equal "1" to enable 4-digit dates.

Restart Excel for the change to take effect.

>> Recommended Download - check, repair and optimize your registry now with Registry Mechanic <<

Disclaimer: Modifying the registry can cause serious problems that may require you to reinstall your operating system. We cannot guarantee that problems resulting from modifications to the registry can be solved. Use the information provided at your own risk.