Can't Filter Tab Delimited CSV Percentages

I need to be able to use a standard filter to show me all rows in a CSV that are above a certain percentage. Percents are listed in the file as:
99.95%
100.0%
99.97%
0.02%
etc.
I cannot seem to make Calc understand that those are numbers that I need to filter. I tried removing the percent signs, reformatting as numbers, re-saving the file in an open doc format, filtering on 90.0, or .9, tried to change the type in the import wizard when I open the file, making sure the strings do not start with a ', and more with no luck. Calc will not understand that the 99.95 or the 99.95% I have in my CSVs are numbers. How can I filter these rows?

Use view, Value Highlighting to make sure the percentages are recognized as numbers, they should show in blue.

When you open the csv file, make sure you enable the checkbox for Detect special numbers. This will allow you to include % in the numbers.

Make sure there are no spaces in front of the numbers. Depending on your data format you might be able to enable space as a separator and enable merge separators.

Enabling space as a separator got rid of a rouge space after the % sign and and I used detect special numbers and now I can filter properly. Thanks!

If the answer solves your question please tick the :heavy_check_mark:.