Setting Different Decimal Separator in Specific Applications in Windows 11
In many parts of the world, the decimal separator is a comma (,), while in other regions, it is a period (.). By default, Windows 11 uses a period as the decimal separator. However, some applications may require a different decimal separator.
Changing the Decimal Separator System-wide
Before changing the decimal separator for specific applications, you may consider changing the system-wide decimal separator. However, this method affects all applications and may cause compatibility issues.
To change the decimal separator system-wide, follow these steps:
- Press
Windows + Ito open Settings. - Go to
Time & Language > Region. - Under
Regional format, select the desired format with the appropriate decimal separator.
Changing the Decimal Separator for Specific Applications
Changing the decimal separator system-wide can cause compatibility issues with some applications. Thus, you can change the decimal separator for specific applications. This method involves changing the Windows system locale.
Follow the steps below to change the decimal separator for specific applications:
- Press
Windows + Rand typeintl.cplthen pressEnter. - Click on the
Additional settingsbutton. - In the
Customize formattab, find theDecimal symbolfield and change it based on the desired separator. - Click
Apply, thenOK.
Changing the Decimal Separator for Microsoft Excel
Microsoft Excel is one of the applications where the decimal separator can be configured independently from the Windows system locale settings. To change the decimal separator in Microsoft Excel, follow these steps:
- Open Excel and go to
File > Options. - Choose
Advanced. Then, underEditing options, find the section forUse system separators. - Uncheck the
Use system separatorscheckbox and set the desired separators below. - Click
OK.
Another way to change the decimal separator for Excel is through changing the Regional settings in the Control Panel.
Changing the Decimal Separator in Google Chrome
Google Chrome does not allow changing decimal separators within the browser. You must change the system-wide default if you wish to change the decimal separator in Chrome.