How to replace dots with commas in Excel

Learn how to replace dots with commas in Microsoft Excel.

Convert selected decimal points (dots) in your spreadsheet to commas using the replace and find tool.

[sydarius]

An easier way to do this: Go to File > Options > Advanced > Uncheck system separators > Set dot as a decimal separator and set a comma as thousands separator > Click ok

[arcynicancer]

You've just saved me hours!!! Thank you!! ❤️

[MisakiOwO]

Thanks for the quick video! Changing the decimal selection in my language setting on Mac wasn't working, this quick method is a life savior!

[henrytyron]

This has been very useful for me. I had spent the whole of the previous day in such of a good directory video but to no avail... until I found yours... THANK YOU!!

[tsheporamantso]

Thank you so much I've spend the entire day going through different complicated videos, only to find out it's just a simple find and reply if only you can imagine how stupid I fell right thank you again.

[philterry]

id give you a million likes if i could.... your vid was straight to the point and i couldnt thank you enough

[pantelisps]

You don't know how much you helped me, about 13.000 wrong values much! Thank you

[anniejames]

Thank you thank you thank you!!! Wasted entire day searching for the answer till I found you!!xx

[RachelGoodwin]

omg thank you, I have been trying to figure this out for months :-0

[RoksanaMajewska-vvgf]

Thank you! Saved me hours and frustration

[rensvlaar]

Search for Hours with difficult youtubs and formulas, and it is so simple. Thanks

[mariethahall]

thank you !! You just saved me MANY hours of frustration!

[nicktsiordos]

Thank you very much. You saved me a lot of time

[redolfsegodi]

You just made my life simple 😂 😁 I'm so happy now

[uqxncyo]

Thanks much, instanty helped and saved a lot of time!

[Dondideeda]

Subscribed, best solution in 15 seconds :-)

[christianearllulab]

thanks man now i can remove units in just a sec

[baneledludlu]

awesome quick and straight forward, many thanks!

[josreekers]

So simple, so quick, such a time saver! Thanks a lot👍

[MS-oyms]

THANK YOU OH MY GOD EVERY REVIEW WAS BAD THANK YOU