If your country’s currency system is in Lakhs and Crores, and not in Millions and Billions, this is what you need to do.

  1. Select all the cells where you want the numbers to then display in Lakhs and Crores (let’s say entire D column).
  2. Right-click and go to ‘Format cells’ (shortcut to go to format cells is Ctrl + 1).
    Format Cells
  3. Select ‘Custom’ and in the ‘Type’ box, type this
    [>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0

  4. Press Ok.

Write 1 Crore (1 with 7 zero’s) and check the output.

Lakhs and Crores