Office Settings & Configuration

Fix Excel Numeric Keypad Entering Period Instead of Comma

Natalie TaylorNatalie Taylor Nov 2, 2026 871 views

Question details

The user experiences an issue where pressing the decimal key on the numeric keypad inserts a period instead of a comma in Excel, despite correct regional and language settings.

How to Fix Excel Numeric Keypad Entering a Period Instead of a Comma
Product
Excel
Device & OS
Windows
Scenario
Entering numeric data containing decimals using the numeric keypad.
Observed behavior
The numeric keypad enters a period instead of the comma configured in the system's regional settings, while other applications correctly accept the comma.
Before you start

Ensure your Windows Regional Settings are correctly configured to use a comma as the decimal separator and restart Excel before modifying application-specific settings.

Solution 1Recommended

Check and Adjust Excel AutoCorrect Options

Sometimes Excel's AutoCorrect feature automatically changes a typed comma into a period. Disabling this specific replacement can resolve the issue.

Excel includes an AutoCorrect feature designed to fix common typos on the fly. Occasionally, a rule may be configured to replace a comma with a period, overriding your keyboard and system settings. Removing this rule will restore standard functionality.

1
Open Excel Options

Click on 'File' in the top-left corner of Excel and select 'Options' at the bottom of the menu.

2
Navigate to Proofing

In the Excel Options window, select 'Proofing' from the left-hand sidebar, then click on the 'AutoCorrect Options...' button.

3
Remove the Comma Replacement

In the AutoCorrect dialog, scroll through the replacement list to see if a comma (,) is set to be replaced by a period (.). If you find it, select that entry and click 'Delete', then click 'OK' to save.

Quick Check: You can temporarily disable AutoCorrect entirely to see if it is the root cause before searching through the list of specific character replacements.
Efficient Spreadsheet Management

Easily Manage Decimal Separators in WPS Spreadsheet

If Microsoft Excel's settings remain unresponsive, WPS Spreadsheet provides a reliable, intuitive way to manage system separators and number formatting without hassle.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing spreadsheet file.
  2. 2. Access Options: Click the 'Menu' button in the top left corner and select 'Options' from the drop-down list.
  3. 3. Adjust Separators: Navigate to the 'Edit' tab, find the separator settings, uncheck 'Use system separators', and explicitly set your decimal separator to a comma (,). Click 'OK' to save.
Intuitive menu for configuring decimal and thousands separatorsFully compatible with Microsoft Excel (.xlsx) file formatsLightweight, fast, and completely free to download and use
microsoft office alternative - wps office

Frequently Asked Questions

Why does my numeric keypad type a dot instead of a comma in all applications?

This usually happens when your Windows Region and Language settings are configured to use a period as the decimal symbol. You can update this in the Windows Control Panel under 'Clock and Region' by altering the 'Additional settings' for date, time, or number formats.

Can I format a cell to display commas without changing global settings?

Yes. You can select the cell, press Ctrl+1 to open 'Format Cells', choose the 'Custom' category, and set a specific number format that enforces a comma. This changes how the number is displayed regardless of the specific keystroke used during entry.

Will changing my keyboard layout fix the numeric keypad issue?

It might. Certain keyboard layouts (such as the standard US QWERTY layout) map the numeric keypad's decimal key strictly to a period. Switching to a localized keyboard layout that matches your specific region can often natively map that key to a comma.