Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
1,293
Views
Topic starter
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".
Can someone please help me. I've been at this for a while.
Posted : 17/03/2022 12:32 am
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.
Posted : 17/03/2022 2:30 am