• 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.

Format numbers from Lakhs to millions


I work in finance department and my reporting is in India and overseas.

Is there any way i can format the cells "," to millions. If i change the regional setting all worksheet becomes in millions and it will be difficult for India reporting.

As now in excel 10,00,000 to 1,000,000 display with any formula or a custom formatting.
Hi Dattathreya,

It is easy. Select the cell that you want to format. Right click on the cell highlighted. Select the format Cell option.. You will get the below widget.
Hope this helps.