Filter Multiple Text in Value column

[Tan_LC]

Hi, I've a table whereby there were different text values and numeric values in the same column.

I tried to uncheck the text value box in Power Query and load the file, below error message pop-up. Please help.

Besides, kindly also advice if there is any method or formula to uncheck different text value box in one click.

Thanks.

Regards,

LC

[v-jingzhang · Accepted solution]

Hi @Tan_LC 

First transform this column to Number data type (decimal or whole number per your need), then remove rows which have errors. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.