Policy
Enable four-digit year display
When this setting is not enabled, Excel follows the Short date style setting under Regional Settings in Control Panel. When this setting is enabled, Excel always displays four digits when you type a date that includes a four-digit year, which may override the Short date style setting under Regional Settings in Control Panel.
PackMicrosoft Office
CategoryMicrosoft Excel 2016 / Miscellaneous
Policy ID
5de25be96169Internal name
L_EnablefourdigityeardisplayRegistry
Copy registry mappings
HKCU\software\policies\microsoft\office\16.0\excel\options\enablefourdigityeardisplay (enabled) = 1
HKCU\software\policies\microsoft\office\16.0\excel\options\enablefourdigityeardisplay (disabled) = 0Policy notes
When this setting is not enabled, Excel follows the Short date style setting under Regional Settings in Control Panel. When this setting is enabled, Excel always displays four digits when you type a date that includes a four-digit year, which may override the Short date style setting under Regional Settings in Control Panel.
Related policies
Block all unmanaged add-insDisable Office Scripts in Excel for Windows DesktopDisable the Office Start screen for ExcelDo not cache network files locallyGraph gallery pathList of managed add-insOLAP PivotTable User Defined Function (UDF) security settingPersonal templates path for ExcelShow custom templates tab by default in Excel on the Office Start screen and in File | New