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.
Pack Microsoft Office
Category Microsoft Excel 2016 / Miscellaneous
Policy ID
5de25be96169 Internal name
L_Enablefourdigityeardisplay Registry
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.