Automatically insert a decimal point
Explanation
This policy setting allows you to configure the "Automatically insert a decimal point" option.
If you enable this policy setting, the "Automatically insert a decimal point" option will be checked and the Places option is set to 2.
If you disable or do not configure this policy setting, the "Automatically insert a decimal point" option will not be checked.
Registry
HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options- Value name
autodec
| State | Value written |
|---|---|
| Enabled | REG_DWORD = 5 |
| Disabled | REG_DWORD = 4 |
PowerShell
PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.
Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.
Enable
# Enable: excel16/L_Automaticallyinsertadecimalpoint
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'autodec' -Value 5 -Type DWordDisable
# Disable: excel16/L_Automaticallyinsertadecimalpoint
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'autodec' -Value 4 -Type DWordRevert to "Not configured"
# Revert to "Not configured": excel16/L_Automaticallyinsertadecimalpoint
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
Remove-ItemProperty -Path $k -Name 'autodec' -ErrorAction SilentlyContinueApplication
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.