title: Excel Formula to convert from cm to inches and feet & round off to two digits
body: <p>I wanted to convert a value from <strong>centimeters</strong> to <strong>Inches and Feet.</strong> in the following format (0' 00'') and I am using the following forumla for this</p>
  
  <pre><code>=INT(CONVERT(A1,"cm","ft")) &amp; " '" &amp;  12*(CONVERT(A1,"cm","ft")-INT(CONVERT(A1,"cm","ft"))) &amp; """"
  </code></pre>
  
  <p>The answer is accurate but the only Problem is The value of Inches has a lot of digits after decimal points..</p>
  
  <p>Please help me how can I round off the Inches part of the value to two digits after decimal point?</p>
  
  <p>Please help me how can I improvise this formula
  Thanks</p>
  
  <p>Saram.</p>
  
  <p><a href="https://i.stack.imgur.com/uRKxC.png" rel="nofollow noreferrer">See Example in the Image</a></p>