Tweak Library – Set Four Digit Year in Microsoft Excel 2000

Tweaks are tricks & hacks for optimizing your system and helps in enhancing & securing your Operating System

All

Home > Software / Applications > Microsoft Office > Set Four Digit Year in Microsoft Excel 2000

Set Four Digit Year in Microsoft Excel 2000

Tweak for : Windows 98, Windows Me, Windows XP, Windows 2003, Windows 2000, Windows Vista

Description:

In Microsoft Excel there are several default formats for the date and the most frequently is the system short date (YY). If you type a date with a 4-digit year (YYYY) in Excel, it will be showed as 2-digit year (YY). This setting enables you to alter the default to 4-digit format.

For this, go to Start > Run menu, enter “regedit” and navigate to the registry path listed below. You can create a DWORD value “EnableFourDigitYearDisplay”, if this value does not exist.

Now, right-click and modify the value to “1” which can set the default as 4-digit format. However, if you want to get back to the original state, change the value to “0”.

Is your PC slow?
optimize performance with

Advanced System Optimizer 3

Set Four Digit Year in Microsoft Excel 2000.reg

The '.reg' file will enable four digit year in 'Microsoft Excel'.

Download

disable Four Digit Year in Microsoft Excel 2000.reg

The '.reg' file will disable four digit year in 'Microsoft Excel'.

Download

Registry Entry Details:

Registry Entry 1 :

[HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options\]

Key Type :

Current User

Value Name :

EnableFourDigitYearDisplay

Data Type :

DWORD (DWORD Value)

Enabled Value :

Disabled value :

Other value :

Value Action :

Add an Entry

Steps ScreenShots:

Apply registry settings according below given steps of screenshots with related changes.

Four Digit Year in Microsoft Excel 2000 is visible.

Four Digit Year in Microsoft Excel 2000 is disabled by default.

First, click the 'Start' button, and select 'Run'. In the resulting dialog box, type "regedit".

Go to [HKEY_CURRENT_USER\Software\Microsoft\Office\9.0 \Excel\Options\],right-click in the open area to create a DWORD Value with the name "EnableFourDigitYearDisplay" in "Options" key.

Next, right-click on "EnableFourDigitYearDisplay" and click on 'Modify'.

Finally, enter the value "1" (Base Hexadecimal) Without quotation in the text box and click on 'OK'. Once you are done. After a restart or logoff, the changes take effect.