Updated: May 12, 2018
Let us see how we can set different currency formats in excel.
In general , in excel we have the English group formatting like 123,456,789.00.
This can be converted into the Indian group formatting like 12,34,56,789.00 and vice versa.
lets see conversion of English to Indian grouping first
The number that i entered in excel sheet is "3500000000" as shown below
And when i click on the Comma function from the menu bar, the number will be grouped into the English format.
Now, Go to Control panel>>Region and Language
In the Format tab, under the drop down menu u will be seeing the default format, here it is English (United States).
Change this to " English (India)" and click on "Apply" and then "OK"
Now you can see the Number "3,500,000,000.00" changing to "3,50,00,00,000.00"
Similarly, if we need to convert this Indian group formatting to the English formatting, just go to Control Panel>>Region and Language and select the "English (United States)" from the drop down and click Ok.
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at firstname.lastname@example.org