New Member
March 16, 2022
I have data in numbers (with commas and a point and two decimals after the point) Excel that I imported on PQ. Once my data is on power query, they are in "any" format. When I try to put them in "currency" format, it displays an error message: "we couldn't convert to number".
Moderators
January 31, 2022
When you change the data type don't choose "Currency" directly. The format that the amounts come in is probably not the same as what you have have in local system settings. Change the data type by "Using locale" and then Currency and specify a format that matches the data source. Probably "English US" will work as that uses comma's as thousand-separators and decimal points.
More about in the attached link.
1 Guest(s)