Forum Discussion
error when converting text to number
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 😞 ...
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
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