Filter for decimals

V

vishu

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?
 
M

Marco

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
 
V

vishu

Hi Marco...thanks a lot

Marco said:
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
Click to expand...
 
Top