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?
------------------------
Watch video How to Convert Comma to Decimal Point & Dot to Comma in Excel online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 13 January 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 132,944 once and liked it 748 people.