Using Power Query, I'm trying to change the type of a column that has values such as this into decimal.

enter image description here

But I get the following error:

DataFormat.Error: We couldn't convert to Number.

This is when in my Advanced Options, the decimal separator seems to be . which is the one used in the column.

enter image description here

5

1 Answer

Try adding an index, then add a custom column with formula

=Number.From([Amount])

Filter that for errors and that will find you your problem data row

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.