If your country’s currency system is in Lakhs and Crores, and not in Millions and Billions, this is what you need to do.
- Select all the cells where you want the numbers to then display in Lakhs and Crores (let’s say entire D column).
- Right-click and go to ‘Format cells’ (shortcut to go to format cells is Ctrl + 1).
- Select ‘Custom’ and in the ‘Type’ box, type this
[>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0 - Press Ok.
Write 1 Crore (1 with 7 zero’s) and check the output.