Enable four-digit year display

Supported on: At least Windows Server 2008 R2 or Windows 7

Registry

HKCU software\policies\microsoft\office\16.0\excel\options

Value name: enablefourdigityeardisplay

Enabled: enablefourdigityeardisplay = 1

Disabled: enablefourdigityeardisplay = 0

Description

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.