Your Regional Settings in your Control Panel on your device are used by default by Excel to determine if decimals should be a period or dot (used in the US and in English Canada for example) or if decimals are a comma (used in many European countries and French Canada).

If you want to use a decimal point instead of a comma as a group or thousands separator, which is different from your Regional Settings, this can lead to issues with your Excel calculations.Įxcel recognizes numbers without group or thousands separators so these separators are actually a format. The default display of commas or decimal points is based on your global system settings (Regional Settings in the Control Panel) and Excel Options. You can change commas to decimal points or dots or vice versa in your Excel workbook temporarily or permanently. The decimal point (.) or comma (,) is used as the group separator in different regions in the world.

Change Separators from Commas to Decimals or Decimals to Commas in Microsoft Excelīy Avantix Learning Team | Updated July 29, 2020Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019 and 365 (Windows)ĭepending on your country or region, Excel may display decimal points or dots instead of commas for larger numbers.

How to change language in excel