Filter for decimals
 

Hi,
I have a list of number in one column.
I want to see the number which has decimals
Eg: 23.96
23.00
22.17
24.00
When I put filter for the above number the result should be 23.96 and 22.17
Can you please tell what the condition I need give in filter option?

Filter for decimals
 

Hi,
I don't know how to define that condition in the filter but you can easily
work it around with an extra column where you test if it's a number with
decimals. If your number to test is in column A2, input :
=IF(INT(A2)<A2,"decimal","integer")

Bye

"vishu" wrote:

Hi,
I have a list of number in one column.
I want to see the number which has decimals
Eg: 23.96
23.00
22.17
24.00
When I put filter for the above number the result should be 23.96 and 22.17
Can you please tell what the condition I need give in filter option?

Filter for decimals
 

Hi Marco...thanks a lot

"Marco" wrote:

Hi,
I don't know how to define that condition in the filter but you can easily
work it around with an extra column where you test if it's a number with
decimals. If your number to test is in column A2, input :
=IF(INT(A2)<A2,"decimal","integer")

Bye

"vishu" wrote:

Hi,
I have a list of number in one column.
I want to see the number which has decimals
Eg: 23.96
23.00
22.17
24.00
When I put filter for the above number the result should be 23.96 and 22.17
Can you please tell what the condition I need give in filter option?