Systweak Tweak Library
Tweaks are tricks & hacks for optimizing your system and helps in enhancing & securing your Operating System
 
 
Skip Navigation LinksHome > Software / Applications > Microsoft Office > Set Four Digit Year in Microsoft Excel 2000
oftware / applications
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.

Tweak for : Windows 98, Windows Me, Windows XP, Windows 2003, Windows 2000, Windows Vista
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”.

Set Four Digit Year in Microsoft Excel 2000.reg

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

disable Four Digit Year in Microsoft Excel 2000.reg

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

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.

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

Category : Software / Applications > Microsoft Office

This setting lets you clear the MRU list Save As Dialog Box of Microsoft Office FrontPage of MS Office XP.

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

Category : Software / Applications > Microsoft Office

This tweak is use to clear the MRU list of Microsoft Office Outlook of MS Office XP.

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

Category : Software / Applications > Microsoft Office

This tweak lets you clear the MRU list of Microsoft Office PowerPoint of save as dialog box in MS Office XP.

Clear recent file list of Publisher in MS Office 2003

Category : Software / Applications > Microsoft Office

If you do not want that other people can see the items you have opened

Deactivate automatic appearance of Microsoft Office 2000 Clipboard toolbar

Category : Software / Applications > Microsoft Office

If you use multiple copy commands in any Microsoft Office application, a Clipboard toolbar will appear automatically. This setting enables you to disable this feature.

 
 
Remove spyware infections automatically / manually | Check for file authenticity
 
Systweak Inc.
© Systweak Inc., 1999-2017 All rights reserved.
Microsoft Gold Certified Partner