Forum Discussion
Replace "." to "," does not work
Hi Lukas,
The reason your replace is not working is because the dataformat is general. You are trying to replace string values while the column doesn't have defined format. If you first convert the column to text, then do the formatting you should get the proper result.
Assuming you're european this is what i advice you to do:
- Format the column to text
- Replace "." with ","
- Format the column to decimal number.
Hope it works!
Resolver IHi,
Please make sure that the first you have converted the column to its necessary format e.g. number or decimal in this case. Then try to use replace function.
Kalpavruksh Technologies | Microsoft Gold Partner
Denmark | USA | India | Germany
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Kalpavruksh,
do you mean to change the format in Power Query?
Because when I did it then I couldnt use replace function
Thanks
Lukas
- tex628
Community Champion
Hi Lukas,
The reason your replace is not working is because the dataformat is general. You are trying to replace string values while the column doesn't have defined format. If you first convert the column to text, then do the formatting you should get the proper result.
Assuming you're european this is what i advice you to do:
- Format the column to text
- Replace "." with ","
- Format the column to decimal number.
Hope it works!Hi tex628,
your solution worked perfectly :)
Thank you
Lukas
This worked well, thank you!