title: How to get numbers into Lakhs with 4 digit decimal roundoff fraction in excel?
body: <p>I like to convert general number into Lakhs along with 4 digit fractional value roundoff in my excel 2013 as below ,</p>
  
  <p><strong>Original Number:</strong> <code>1234567</code></p>
  
  <p><strong>Formatted Number:</strong> <code>12.3457</code> (This no is converted multiples of  Lakhs and roundoff with 4 fraction digits).</p>
  
  <p>As a workaround, using <code>#\.00000</code> the custom formula in excel (right click number cell -> Format Cells -> under Number tab click "custom" -> In "Type" enter the formula) I made it to display as <code>12.34567</code>. But I couldn't roundoff this into 4 fractions digits. How to make it?</p>