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.

Supported on: At least Windows 7

Registry HiveHKEY_CURRENT_USER
Registry Pathsoftware\policies\microsoft\office\16.0\excel\options
Value Nameenablefourdigityeardisplay
Value TypeREG_DWORD
Enabled Value1
Disabled Value0

excel16.admx

Administrative Templates (Computers)

Administrative Templates (Users)