Windows 8 Windows 8 Excel 2013 Thousands Separator India

nishant91

New Member
Joined
Aug 13, 2013
Messages
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
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...
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).
 


Solution
Back
Top