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"