Excel 2007 : Default Comma Style

**navajo_23** · 03-23-2010, 10:55 AM

Hello, I have accidently deleted the Default Comma Style.
How can I restore it resp. choose another number format as Default Comma Style?
Cheers!

**shg** · 03-23-2010, 04:16 PM

Welcome to the forum.

Create a new style named Comma and set the number format as

_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

**navajo_23** · 03-23-2010, 04:33 PM

Thank you very much, unfortunately I do not know how to name a new style. I can go to "Format Cell, Number, Custom" and create a new one but how can I name it and assign it to the "comma icon" in the Ribbon?
Cheers!

**navajo_23** · 03-23-2010, 05:13 PM

For now, I have created a small macro:

Sub Comma()
'
' Comma Macro
'
' Keyboard Shortcut: Ctrl+m
'
Selection.NumberFormat = "#,##0.00"
End Sub

but I am still very interested in knowing how to assign my favourite formats to the shortcuts on the ribbon.

Thank you for your help
Cheers!