I get the ¤ in a decimal number column, how do I solve this? Intersting error!

[simber]

Hi!

I get the ¤ at some rows in a column I import when I the data. If I look at the data in Power Query I can see that it's a decimal number (which it should be!) but if I view the data in the normal editor i get the ¤ symbol.

In power Query, the marked value/column is the same column as above:

I can't choose to filter out the ¤ by applying the filter at the top and I can't use ISNUMBER() to check wheter is a number, it just returns true. I've also tried to use an IF statement to check for "¤¤¤" but it doesn't work because this column is a decimal number column.

On the topic on the type of column, might it be due to what I have chosen at the top?:

[v-yiruan-msft]

Hi @simber ，

Sorry that I can't reproduce your problem. Could you please check which data in the power query corresponds to the data circled in red? Please share some sample data in your query and applied codes in Advanced Editor. Thank you. 

Power QueryData view

Best Regards