4
4
Currently the Excel default formatting is:
1,000,000
500,000
How do you format the number to use the comma separator (,) like this
10,00,00,000
50,00,000
This is is how Indian Currency (Rupees, INR, ₹) is normally represented.
ramji
Posted 2015-06-16T09:41:54.867
Reputation: 111
11
Some currency systems require a slightly different comma schema. With data like:
applying this Custom Number Format:
[>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0
will produce:
Gary's Student
Posted 2015-06-16T09:41:54.867
Reputation: 15 540
2"Note that the original question is written wrong for India. In India the lowest-value 3 places are grouped together, then pairs of digits in higher places separated by commas. 100 1,000 10,000 1,00,000 10,00,000 1,00,00,000 and so on. So the results displayed in the answer above are actually correct for India." - Phil Davis – user193661 – 2015-11-27T06:44:24.663
2
There is a better and permanent solution (for Indian users):
Add Region as India and language as English(India). Then you can see the Indian comma format and Indian currency symbol inplace of dollar symbol. Default setting in US and English(US).
Go to Control panel > Region (search)
(tab) Format : Select English(India)
Click Laguage Preferences and add English(India) and move up to top.
Press OK
hkchakladar
Posted 2015-06-16T09:41:54.867
Reputation: 141
The question clearly states that the user wants to format in Excel not system wide – Mr.X – 2019-08-04T10:03:24.913
1What? You want it to have commas at position 3 and 5? 6? Between 0s? Is this for a currency? Your question is very unclear – Raystafarian – 2015-06-16T11:55:55.820
Yes i want to put comma in 3 then 5 then 7 then 9 and so on position. This is because of my currency which is rupees. Kindly give me some solution for that.. – ramji – 2015-06-16T14:23:15.650
1http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/ – Excellll – 2015-06-16T14:42:13.457