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

1. 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.
   
2. 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.
   
3. 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.