The Comma button/icon

[bwong]

When using the comma button/icon, it also adds 2 decimal places.

Is there a way to customise this button/icon... make it default not to
include the decimal places?

Thanks
Ben

 

[Jacob Skaria]

Select the cell range. Right click>Format CElls>Custom format to

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

 

[bwong]

Thanks for the reply. But is there a way to change the default of the comma
button/icon.

Cheers
Ben

 

[Dave Peterson]

Clicking the comma icon applies the Comma style.

So if you change the comma style
In xl2003 menus:
format|style|select Comma|click modify

Be aware that styles live in workbooks, so this change will only change the
style in the active workbook.

But you could create a book.xlt template workbook in your XLStart folder that
has this modified style.

xl2003 and below will use that template workbook when you create a new workbook
by clicking on the new icon on the standard toolbar.

 

[pmartglass]

Have you tried writing a macro and saving it to a button on a custom toolbar ?

 

[Dave Peterson]

Nope.

I like the comma button the way it is.

Have you tried writing a macro and saving it to a button on a custom toolbar ?

 

[bwong]

Thanks for the replies pmart and dave

Have you tried writing a macro and saving it to a button on a custom
toolbar ?