Transforming a text value into a number with Power Query
I have an issue with Power Query since a few days regarding number formating.
We export a data from Google Adwords in a CSV, then work on the CSV from within Power Query to build our reports.
For instance, I will see 91.31€ as a conversion value directly in the interface, while hoping to see 91,31€ in my PBI Report since I am based in Europe. Normally that works fine with the automatic data recognition, but now the CSV itself contains the formating issue. The problem comes in when the data is downloaded. I have no issue in PBI for other sources in CSV.
In Power Query, the default value for this is text. When I change it to decimals, I get 9131. I tried to use the function "change type" and to set it up directly as a currency for my country there, but it delivers the same result.
Is there any way to replace points by commas automatically before I switch from text format to currency?