Windows 8 Excel 2013 Thousands Separator India

Discussion in 'Windows 8 Help and Support' started by nishant91, Aug 13, 2013.

  1. nishant91

    nishant91 New Member

    Joined:
    Aug 13, 2013
    Messages:
    1
    Likes Received:
    0
    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.
     
  2. Mike

    Mike Windows Forum Admin
    Staff Member Premium Supporter

    Joined:
    Jul 22, 2005
    Messages:
    8,488
    Likes Received:
    783
    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).
     

Share This Page

Loading...