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.