title: Excel formula for count numbers of decimals
body: <p>I need to count the numbers of decimals places of a number.</p>
  
  <p>The A1 cell value is:</p>
  
  <pre><code>    123456.78.
  </code></pre>
  
  <p>The formula in B1 is: </p>
  
  <pre><code>    =LEN(MOD(A1,1))
  </code></pre>
  
  <p>The results of MOD(A1,1) is:</p>
  
  <pre><code> 0.78
  </code></pre>
  
  <p>I expected the LEN to be 4 (LEN(0.78)=4). 
  The Excel formula calculates 17 because the forumula returns:</p>
  
  <pre><code>0.779999999998836
  </code></pre>
  
  <p>Should I try a different approach? For example looking for the separator char?</p>
  
  <pre><code>=LEN(A1)-FIND(".",A1)
  </code></pre>