title: EXCEL formula for significant digits
body: <p>I am searching for an Excel formula to get the amount of significant figures from a decimal number or integer (I realized that cell needs to be string to have trailing zeros)</p>
  
  <p>For example:</p>
  
  <p>from an integer I can do:
  <code>=len("113")</code> which has 3 sig. digits</p>
  
  <p>also for a decimal number >=1 or &lt; 1 I can cut out the dots:
  Let's say H19 has 1.13 inside:</p>
  
  <blockquote>
    <p>=IF(VALUE(H19)>=1;LEN(SUBSTITUTE(H19;".";""));LEN(SUBSTITUTE(H19;"0.";"")))</p>
  </blockquote>
  
  <p>This formula give me 3 sig. digits or let's say 0.13 will give me 2 sig. digits as "0." will be removed from string.</p>
  
  <p>Can I somehow include all possible cases which can occur let's say: "0.000300"?  "300" are the sig. digits so 3 is the result.</p>
  
  <p>With my formula it would not correctly work.</p>
  
  <p>A second problem is, my formula now works only if someone uses a dot as decimal separator but it breaks with a comma. Unfortunately it really has to be a formula and not a macro.</p>
  
  <p>I googled a lot but I couldn't find a solution to cover all aspects.
  Can someone help?</p>