Count the number of decimals (Excel version)
Solved
Jerome
-
reppa Posted messages 2 Status Membre -
reppa Posted messages 2 Status Membre -
Hello,
My issue is that I have a large list of numbers in Excel (English version). Each number has between 0 and 6 decimal places. My problem lies in the fact that I need to count the number of decimal places after the decimal point for each number and I can't seem to find the appropriate formula....
Could someone help me with this?
Best regards,
My issue is that I have a large list of numbers in Excel (English version). Each number has between 0 and 6 decimal places. My problem lies in the fact that I need to count the number of decimal places after the decimal point for each number and I can't seem to find the appropriate formula....
Could someone help me with this?
Best regards,
4 réponses
Hello,
Let's talk Mathematics:
Let N be a number with X digits and Y decimals... The number of digits after the decimal point is equal to the total number of digits making up this number minus the number of digits in its integer part minus 1 (the decimal point!!!)
So in Excel, you write any decimal number in A1, and in B1:
=LEN(A1)-LEN(INT(A1))-1
this gives us the number of digits after the decimal point!
Magical... no Mathematics.
Now maybe there's a formula that gives it to us directly, but I don't know it...
--
Franck P
Let's talk Mathematics:
Let N be a number with X digits and Y decimals... The number of digits after the decimal point is equal to the total number of digits making up this number minus the number of digits in its integer part minus 1 (the decimal point!!!)
So in Excel, you write any decimal number in A1, and in B1:
=LEN(A1)-LEN(INT(A1))-1
this gives us the number of digits after the decimal point!
Magical... no Mathematics.
Now maybe there's a formula that gives it to us directly, but I don't know it...
--
Franck P
Sorry for my rush, you were asking in Excel English...
here it is:
=LEN(A1)-LEN(INT(A1))-1
Excuse me, Sir!