So I have not really used PowerQuery in the past. I have a data set with thousands of rows of numbers. Some of these numbers are actually text (1S432490). I know I could probably use a macro to remove the rows of text, but I kind of want to stay within PowerQuery if there is a way to remove these rows of text.

The reason I am asking this is because I want to create a filter between two values within PowerQuery, but it's giving me some error about format, and then when I manually go into my table and remove those rows that contain text, my filter then works.

Thanks for the help.