error when converting text to number

[Anonymous]

Community, I am trying to convert text to number (or currency). I am still very new to Power Query so i am sure this is somethign rpetty simple but i literally spent 5h trying to figure it out 😞 

please help

[v-angzheng-msft]

Hi, @Anonymous 

Select the target column, click the Data Type drop-down option in the UI to select the data type you want, or click Detect Data Type.
If you can't convert to numeric type successfully, there may be invisible non-printing characters in the column. You can click the format drop-down option in the UI, select Trim in the options, and then convert the data type.

Tip: Data is left-aligned for text types, and right-aligned for numeric types.

If you need to format the data in the column as currency, select the column in PowerBI and click the format icon in the UI.

Best Regards,
Community Support Team _ Zeon Zheng

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

[kumar27]

This worked out perfectly , Thanks

[Anonymous · Accepted solution]

I would Select the columns Amount 1 and Amount 2, right click, and choose   Change Type, then Using Locale, and then select whichever locale, but United States or us-En (I can't remember the parameters but it's a dropdown). Then select "Currency" as the type.

Good Luck!

--Nate