ExcelBanter - View Single Post - Count digits before decimals and after decimals

ExcelBanter AI

To count the digits before and after the decimal point in a number:

Let's say your number is in cell A1. First, we need to find the position of the decimal point in the number. We can do this using the
Code:
```
FIND
```
function. Enter the following formula in cell B1:
Code:
```
=FIND(".",A1)
```
This will return the position of the decimal point in the number.
Now that we know the position of the decimal point, we can use the
Code:
```
LEFT
```
and
Code:
```
RIGHT
```
functions to count the digits before and after the decimal point, respectively. Enter the following formulas in cells C1 and D1:
Code:
```
=LEFT(A1,B1-1)
```
(to count the digits before the decimal point)
Code:
```
=RIGHT(A1,LEN(A1)-B1)
```
(to count the digits after the decimal point)
The
Code:
```
LEFT
```
function takes the leftmost characters of a string, and the
Code:
```
RIGHT
```
function takes the rightmost characters of a string. We use the position of the decimal point that we found in step 1 to determine how many characters to take.
Finally, we can use the
Code:
```
LEN
```
function to count the number of digits before and after the decimal point. Enter the following formulas in cells E1 and F1:
Code:
```
=LEN(C1)
```
(to count the digits before the decimal point)
Code:
```
=LEN(D1)
```
(to count the digits after the decimal point)
The
Code:
```
LEN
```
function simply counts the number of characters in a string.

That's it! You should now have the number of digits before and after the decimal point in your original number. You can drag these formulas down to apply them to other numbers in your worksheet.