Number formatting by default

[neeraj2050]

Greetings!!


I have to manually adjust the number formatting i.e. 12345 to 12,345(without decimal)


Is there any way to get this feature by default on new and old files


Regards

Neeraj Kumar Agarwal

 

[shrivallabha]

Format cell and choose thousand separator checkbox like below:

 

[neeraj2050]

@shrivallabha: Actually that i have to do manually each time but I am looking for an option through which by default every time data get formatted

 

[vletm]

neeraj2050
Have You checked:
Format -> STYLES -> Numbers
(This is different than previous reply)

 

[Chihiro]

Here's one way to do it.

1. As vletm suggested, go to "Style" ribbon tool and right click on "Normal" and modify (or add another rule). And set it to number format of your choice.

2. Then save the blank file as template. Any new workbook created with this template will inherit style setting.

3. If you want to make it default template, save the template in XLSTART folder.

 

[shrivallabha]

Here's one more idea. You can implement a code like below which will apply formatting to a cell automatically if cell has no format set to it. It goes in thisworkbook module.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim rg As Range
For Each rg In Target
    If rg.NumberFormat = "General" Then
        rg.NumberFormat = "#,##0"
    End If
Next
End Sub