Filter column with Less Than condition on values that ends format ".00"

[kostya572]

I have this data in column D:

5400.00
1200.00
1000.00
700.00
100.00
59.70

Then i use “Standard Filter” on “Column D” with “<=” (less than) condition with value “1000.00”
In result i have output:

1000.00
100.00

What can i make to get this output:

1000.00
700.00
100.00
59.70

I think the problem in ending pattern format “.00”.

[mariosv]

With standard filter besides the <= condition add a new AND condition = ^(?!.*\,.*).* if your decimal separator is dot then change \, with \., remember activate regular expressions in Options.

The expression finds all values without decimals, but if they are values not formulas.