Number system grouping in Indian system in Excel

By default all computer have number grouping of 1000 separator system, like ###,###,###. But we Indians follow 1000 and 100 separator system like ##,##,###. We can change this default setting to the Indian System in Windows 7. I have not checked in Windows XP.

Follow the below steps to change the default settings

An easy way by means of Windows Search

1. Press Windows Button
2. Type "Regional Settings" in the search box
3. select "Change the date, time and number format"
4. In the "Formats" tab select "Additional settings"
5. Under the "Numbers" tab see Digits Grouping" and change it to the Indian system.

Manual steps if you don't have Windows Search

1. Go to "Control Panel"
2. Select "Region and Language" or if you have a Categorized view select "Clock, Language, and Region" and "Change the date, time and Number format".
3. Go to Step 4 above






1 comment:

  1. Wow! these are wonderful tips. Thanks for sharing them with us. Please visit https://goo.gl/0KV9uU

    ReplyDelete

How to copy screenshot to clipboard in New Apple Mac OS

If you have upgraded your Apple Mac OS to 14.x.x, then you may find it strange that the screenshots are not copied into the clipboard. The s...