Fix Excel Numeric Keypad Entering Period Instead of Comma
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.

- 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.
Ensure your Windows Regional Settings are correctly configured to use a comma as the decimal separator and restart Excel before modifying application-specific settings.
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.
Click on 'File' in the top-left corner of Excel and select 'Options' at the bottom of the menu.
In the Excel Options window, select 'Proofing' from the left-hand sidebar, then click on the 'AutoCorrect Options...' button.
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.
Verify Excel Advanced Editing Settings
Excel has its own dedicated setting for decimal and thousands separators that can override your Windows system settings.
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. Open WPS Spreadsheet: Launch WPS Office and open a new or existing spreadsheet file.
- 2. Access Options: Click the 'Menu' button in the top left corner and select 'Options' from the drop-down list.
- 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.

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.




