• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conversion from Thousands to Crores


Well-Known Member
what are crores? Remember this is an international forum and not everyone knows all terminology. Posting a before and after scenario would be very helpful.


New Member
1 Crore = 0.01 Billion, Crores and Lakhs of Rupees are dealt in India. I made a pivot table on Revenue Budget using power Query, wherein all the Numbers are displayed by default in Thousands of Rupees. As 10,000 Thousands make One Crores, if I use number formatting like #,##0.0,, will give me in Ten Lakhs of Rupees and if I use #,##0.0,,, this will give me Number of Rupees in Hundred Crores. I need to display only in Crores. Thanks in advance for your kind support.