Set Four Digit Year in Microsoft Excel 2000

Click here to run a free scan for registry errors

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.

Level: Recommended For Novice Users

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. When editing the registry it is highly recommended to run a quick scan for optimization, you can test your system now for free.

Quick Navigation

Screenshots | Registry Entries | Related Tweaks | Library Categories | Free Registry Scan

Screenshots

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.

Click here to run a free scan for registry errors

Registry Entries

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

Click here to run a free scan for registry errors

Related Tweaks

Show task pane in MS Office 2003.

Clear recent file list of Excel in MS Office 2003

Change places bar icons size in MS Office 2003

Show desktop in places bar of MS Office 2003

Hide My Documents in places bar of MS Office 2003

Show Publishing/Network in places bar of MS Office 2003

Show Recent in places bar of MS Office 2003

Add user specific items to My Places Bar in MS Office 2003

Clear recent file list of MS Excel

Set the number of times the Microsoft Excel is able to undo the operations or command

Clear the MRU list of Microsoft Office Word of MS Office XP

Clear the MRU list of Microsoft Office Word of MS Office 2003

Clear the MRU list of Microsoft Office Excel of MS Office XP

Clear the MRU list of Microsoft Office Excel of MS Office 2003

Clear the Save As MRU list of FrontPage in MS Office XP

Clear the MRU list of Microsoft Office FrontPage of MS Office 2003

Clear the Create or Open Outlook Data File MRU list in Outlook of MS Office XP

Clear the MRU list of Create or Open Outlook Data File in Microsoft Office Outlook of MS Office 2003

Clear the Save as MRU list of PowerPoint of MS Office XP

Clear recent file list of PowerPoint in MS Office 2003

Clear the MRU list of Microsoft Office PowerPoint of MS Office 2003

Clear recent file list of Publisher in MS Office 2003

Embedding pictures in RTF files in Word 2003

Deactivate ClearType reading layout mode.

Add a User Defined Folders in Places bar

Specify the View of the Contents in User Defined Folders in Places Bar

Hide the System Folder Desktop in the Places Bar

Hide the System Folder MyDocuments in the Places Bar

Hide the System Folder MyComputer in the Places Bar in MS Office 2003

Hide the System Folder Favorites in the Places Bar

Hide the System Folder Publishing/Network in the Places Bar

Hide the History system folder in the Places Bar.

Deactivate automatic appearance of Microsoft Office 2000 Clipboard toolbar

Configure Office URL Office on the Web Link in Office 2000

Define the location of your template folder path of Microsoft Office 2000.

Define the default location of your Word Files Folder of Microsoft Office 2000.

Define the default location of your PowerPoint Folder of Microsoft Office 2000.

Set Four Digit Year in Microsoft Excel 2000

Set the number of undo-operations for Microsoft Excel 2000

Delete recent file list of Microsoft PowerPoint

Change places bar icons size in MS Office 2000

Add an item User Defined Places in MS Office 2000

Show desktop in places bar of MS Office 2000

Show Favorites in places bar of MS Office 2000

Show My Documents in places bar of MS Office 2000

Show Publishing/Network in places bar of MS Office 2000

Show Recent in places bar of MS Office 2000

Click here to run a free scan for registry errors

Tweak Library Terms

Contents

Registry Entries
Screenshots
Related Tweaks
Library Categories
Free Registry Scan

Recommended: