Hi, I am doing some programming where I need to know the number of
digits of the only decimal part of a number. . . .
...
In cell B1 I wrote the following : =LEN(A1-INT(A1))

Use

=LEN(ABS(A1))-LEN(INT(ABS(A1)))-(A1<INT(A1))

instead.

Here is a shorter formula which also appears to work...

=MAX(0,LEN(A1)-FIND(".",A1&"."))

Rick