Download the featured file here https://www.bluepecantraining.com/how-to-convert-comma-to-decimal-point-dot-to-comma-in-excel/

In this video I demonstrate how to convert European numbering (1.987,09) to UK numbering (1,987.09). In other words how to convert thousand-separators from full-stops to commas and decimal points from commas to full-stops.

I use two methods: one with formula and one without.

This will be useful if you are asking the following questions:

Why does Excel use a comma instead of a decimal point?
Can a comma be used as a decimal point?
How do I change a comma to a period in Excel?
How do I change a comma to a dot in Excel?
How do you use a comma separator in Excel?
How do you change period to comma in Excel?
------------------------