Display numbers in lack and crore

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).
Format Cells
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.

Leave a Reply


Your Cart

No products in the cart.
Start shopping

About Us

Royal Technologies is a System Integration house that supports Web Design, Web Hosting, Domain Registration, Search Engine Optimizing, IT Consulting, Remote or Telephone Support and Software Development. In simpler terms it’s an IT Company dealing in various aspects of implementation and maintenance of computerization. We have learnt from experience and have molded ourselves to be complete IT Company.



Copyright © 2008-2024 Royal Technologies. All rights reserved.
Development by Royal Technologies