Do you get your formula to work on all numbers? I have done some quick
testing and I am not seeing correct results.

Rick


"Teethless mama" wrote in message
...
Flaw designed...

You have to use round function

=LEN(ROUND(A2-INT(A2),2))


"Yara" wrote:

Hi,

Did anybody tried the following formula:

LEN(A1-INT(A1)) the output should be the number of decimal
digits
of the number in cell A1.

Examples:
in cell A1 input the following formual: +LEN(A2-INT(A2))
in cell A2 input different numbers like the following:

Cell A2 Cell A1
2.2 3
5 1
10.25 4
9.2 17 What
100.1 18 What again !!!!

Can anyone figure what is happening

Yara