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’... Read More »