Power Query -> Transform Comma to Period and Obtain Decimal Numbers
<p>I'm working within Excel Query Editor (Power Query) and I have a table with many columns. </p>

<p>Some of the numbers in those columns have a period (".") and they are properly recognized as decimal numbers, but some of them have a comma (",") and they are seen as text.</p>

<p>I'm trying to use Query Editor's Replace Value function in order to replicate Excel's Find and Replace function (CTRL+H) and simply change the "," with "." but without any luck so far. </p>

<p>Do you know a fix to this, please? Thank you very much.</p>