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?
------------------------

[OweisAzizi]

OMG you saved my life. I struggled with the wrong decimal on my mac for YEARS. The general instruction to change the decimal in the language settings didn't work for me. 1000x Thanks!!!

[Muuip]

"Text to column" solution and setting the actual decimal and tausend separators works great! Keeps dates intact.
Great solution for international .CSV, .TSV and .TXT files! Much appreciated!👍

[Mukundwa]

THANKS SO MUCH! text to column has sorted out my grievance. No other video helped

[kinnuggies]

thank you very much sir. i have been searching for this tutorial for ages! god bless you.

[broadbandtogod]

This literally saved my sanity
*THANK YOU*

[annb]

thank you a lot! the second method with formula worked for me.

[johreh]

Great, thanks for this. The formula option worked great for me.

[TishSerg]

I watched your vid from article on another site. It appeared so useful, so I took care to go directly to YouTube to like it.
Other sources proposed some clunky methods I was using before, but now I can use your comprehensive methods. Thank you for this.

[QuaquJames]

This video just saved my day. Thanks for sharing ❤

[huseyinakgun]

Thank you so much for video. I hope you are healty and fine :)

[girayarn]

amazing! simple and useful options to solve sap exported excel file's discrepancy. This ease my day a lot. Thanks!

[amosolalekanakinyemi]

Explicit explanation. I kowtow. I gallivanted around before encountering this video.

[JackieFrank]

Awesome! This has been a pain for me to deal with in excel, since my default is set to US/UK while I often need European notations too. Very happy to now know that the formula NUMBERVALUE exists (because the text to columns only works if you want to convert whatever you have to your default). Thank you very much!

[nicolasbrinez]

Very useful. I basically needed the last option you gave. Thank YOU!

[thesunshine]

very useful clip. many thanks chester. i used to this manually and it is really very tedious.

[haniabobakr]

I watched over 10 tutorials, thank you v.much

[M-N-S]

Thanks for your very descriptive video, can you pls share the same using Excel for MAC on MAC system because on MAC finding these options is difficult.

[pradeeppanicker]

very much concise and clear understanding

[cshemantpawar]

thanks
Its very useful and easy to understand from you

[khanyisakamela]

Thank you so much for this video. That last option helped me a lot!! So grateful. 🙏🏽