ADMX Viewer
excel16.Office.Microsoft.Policies.Windows• User

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.

Policy Details

Policy Name
L_Enablefourdigityeardisplay
Registry Key
software\policies\microsoft\office\16.0\excel\options
Value Name
enablefourdigityeardisplay
Supported On
At least Windows Server 2008 R2 or Windows 7
Policy State Values
Enabled: 1
Disabled: 0
Available Languages
en-us