- 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.
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
- Joined
- Jul 22, 2005
- Messages
- 9,241
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:
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).
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.00You 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).