 |
Set Four Digit Year in Microsoft Excel 2000
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.
Click Here to Run a Free Scan for None Related Errors
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.
Level: Recommended For Novice Users
Path: [HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options\] |
Location: Current User |
Value Name: EnableFourDigitYearDisplay |
Data Type: DWORD (DWORD Value) |
Enabled Value: 1 |
Disabled Value: 0 |
Action Type: Add an Entry |
|
 |
First, click the 'Start' button, and select 'Run'. In the resulting dialog box, type "regedit". |
|
 |
Go to <b>[HKEY_CURRENT_USER\Software\Microsoft\Office\9.0 \Excel\Options\]</b>,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. |
|
|
Page:
microsoft_office
-
1
|
|
