Question

Excel: point instead of comma - this is how it works

Answer 1

How to change the decimal point in Excel
1st step:
2nd step:
3rd step:
4th step:
quick start Guide

---

Would you like to replace the decimal points with periods in a table? We show how it's done..

The comma is used as a decimal separator in Europe - but not in the US, UK, and Australia. Instead, a period is used here. If you edit an international table and want to replace all commas with periods there, you do not have to do this manually. How to replace the commas with periods in Excel, read below.

How to change the decimal point in Excel

Note : If you change this setting, it will affect all numbers in all workbooks that you open from then on until you change them again. You cannot change the setting for specific cells only.

Follow our step-by-step instructions or take a look at the brief instructions ..

1st step:

In Excel, click File in the upper left corner .

2nd step:

Now select the " Options " entry on the left .

3rd step:

Then switch to the " Advanced " category . Then remove the check mark on the right next to " Use separator from operating system ". Only then can you edit the text fields next to " Decimal separator " and " Thousands separator ". So enter the character you want to use in each of the edit boxes (so a period in this case) and click OK .

4th step:

The new separators are automatically inserted into any numbers in your workbook that use them.

quick start Guide

1. In Excel, open " File " in the upper left corner, then select " Options " on the left.
2. In the " Advanced " category , uncheck " Use separators from operating system ".
3. Then enter the desired character (ie a point) for " Decimal separator " and " Thousands separator" and click on " OK ".

---