Forum Discussion
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 "...
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.
V-lianl-msft with replace values we can replace only numbers not (.) any other alternative?
V-lianl-msft
Community Support
Community SupportHi 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.
V-lianl-msftThank you