Windows 8 Excel 2013 Thousands Separator India

#1
Hello,

I stay in India. I was using Windows 7 and Office 2010. In the regional settings in Windows 7, I had selected "English (India)" and therefore, Excel 2010 was putting the thousands' separator as per the Indian Rules. In Windows 8 also, I've selected "English (India)" in my regional settings, but Excel 2013 is not putting the thousands' separator properly. Here is how it is putting it: 1234,56,789. It should have put it this way: 12,34,56,789. Please help.
 


Mike

Windows Forum Admin
Staff member
Premium Supporter
#2
Here are some links about this:

http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/
Seems generic and may not work for you.

However, we get a bit deeper here for Excel 2013:
http://www.excelforum.com/excel-formulas-and-functions/863048-indian-style-comma-separator.html

Something like cell format:
Code:
[<100000]##,##0.00;[<10000000]#\,##\,##0.00;[<1000000000]#\,##\,##\,##0.00;[<100000000000]#\,##\,##\,##\,##0.00;#\,##\,##\,##\,##\,##0.00

OR

[<100000]##,##0.00;[<10000000]#\,##\,##0.00;[<1000000000]#\,##\,##\,##0.00;#\,##\,##\,##\,##0.00

OR

[<100000]##,##0.00;[<10000000]#\,##\,##0.00;#\,##\,##\,##0.00
You do this by highlighting and right-clicking the cells. Under currency use "Custom" and input these variables until one works (presumably the correct format for Rupees).
 


This website is not affiliated, owned, or endorsed by Microsoft Corporation. It is a member of the Microsoft Partner Program.
Top