How to Convert Comma to Decimal Point & Dot to Comma in Excel
Download the featured file here https://www.bluepecantraining.com/how...
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?
------------------------
