Enable four-digit year display
Jump to overview

Policy overview

Key metadata and intent for this policy.

User
Category
Microsoft Excel 2016 > Miscellaneous
Supported on
Windows7

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.

Internal name
L_Enablefourdigityeardisplay
Policy ID
5de25be96169
Elements
0

Registry values

How enabled and disabled states update the registry.

ScopeRegistry locationTypeEnabled valueDisabled valueCopy
User
Path
software\policies\microsoft\office\16.0\excel\options
Value name
enablefourdigityeardisplay
REG_DWORD
HKCU
1
HKCU
0
Registry location
Type REG_DWORD · User
Path
software\policies\microsoft\office\16.0\excel\options
Value name
enablefourdigityeardisplay
Hive
HKCU
Enabled value
1
Disabled value
0

Policy elements

Inputs and configuration options exposed by this policy.

This policy has no additional user input fields.