📎 AI Summary:
The user from India reports that while regional settings in Windows 8 are set to "English (India)," Excel 2013 does not display the Indian-style thousand separators correctly, showing incorrect formatting (e.g., 1234,56,789 instead of 12,34,56,789). The second post provides links and example custom formats to achieve the proper Indian currency comma placement, suggesting adjusting cell formats in Excel through custom formatting options. Overall, the thread addresses a formatting issue with Indian-style number separators in Excel 2013, with helpful guidance on customizing formats to resolve it.
N

nishant91

New Member
Joined
Aug 13, 2013
Messages
1
Thread Author #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.
 

Solution
Mike
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...
Sort by date Sort by votes
Mike

Mike

Windows Forum Admin
Staff member
Premium Supporter
Joined
Jul 22, 2005
Messages
9,260
#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).
 

Upvote 1 Downvote
Solution
You must log in or register to reply here.