title: Displaying Lakhs and Crores in Google Sheets
body: <p>I would like to use Google Sheets for its convenient global access, but I really need to display numbers in Lakh and Crore (Indian style) format to avoid confusion among managers.</p>
  
  <p><code>150,000</code> should display as <code>1,50,000</code> and <code>12,000,000</code> should display as <code>1,20,00,000</code>.</p>
  
  <p>I tried setting the format to <code>##,##,##,000</code> but my number still displays as <code>12,000,000</code>. I couldn't find anything <a href="https://support.google.com/docs/answer/56470?hl=en">in the docs</a>.</p>
  
  <p>Does anyone know of a way to accomplish this?</p>