Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to replace dot in decimal numbers to comma (not thousand separator!)

Please, in your answer, don't mention "thousand separator" or "regional settings".   How can I replace dot in all decimal numbers to comma as a mass replacement in a column? The column is already "...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Anonymous ,

     

    You may get the result you want by using the "substitute" function.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

 

You can achieve this in Power Query using the "Replace values" function under the "Home" tab