How to Extract the decimal digit from the value

[ajmal pottekattil yoousuf]

Extract the decimal digit count.

[#2]

@ajmal pottekattil yoousuf 

Why would 15 have a decimal count of 1? I would say it should be 0 since there is no decimal separator...

[#3]

It should be zero.
mistake is happen.

[#4 · Accepted solution]

Hi @ajmal pottekattil yoousuf 

One way, in C3:

=IFERROR(LEN(B3) - SEARCH(".",B3), 0)