I want to extract numbers as explained below:
Data entry as follows: DZN.Numbers
Numbers go from 0-11
(for eg:)
0.1 means 1 number
.....
0.9 means 9 numbers
0.10 means 10 numbers
0.11 means 11 numbers
If I use mod function I get the decimal/number part but The problem happens only when I have to distinguish between 0.1(1 number) and 0.10(10 numbers) What logic can I use in google sheets to extract the number from entered data? Please help!!