How to set default Number Format in Excel in Hundred thousands, example 100,000

SiddharthJ 

As far as I know, the default format is "General" and there's nothing you can do to change it. You will have to do this manually. The quickest way would probably be to hit Ctrl + A to mark all cells and then lick here: