Modify Toolbar Button Styles

[Guest]

The comma button on the formatting toolbar is set to apply the "Comma" style
and formats numbers with a comma separator and two decimals. I am trying to
apply the "Comma [0]" style to this button permanently, so that I get the
comma separator, but no decimals.

I can do this easily by modifying the "Comma" style (Format - Style - Comma
- Modify), but when I open a workbook , the style reverts back to the
original format with two decimals.

How can I apply this style change permanently to all workbooks?

 

[Dave Peterson]

Not with styles.

You could create your own macro that applies the formatting that you want and
create a button and use that.

But styles live in workbooks.

You could create a new workbook and change the style the way you like. Then
save it in your XLStart folder as book.xlt (a template file).

Whenever you click on the new icon on the standard toolbar, that template
workbook will be used as the basis for the new workbook. And the new workbook
will have this modified style.

And if you want to change the style of an existing workbook, you can use
format|style and modify it manually.

Or you can open a workbook with one of your modified styles and use that same
dialog (format|style) to merge into the other workbook.

The comma button on the formatting toolbar is set to apply the "Comma" style
and formats numbers with a comma separator and two decimals. I am trying to
apply the "Comma [0]" style to this button permanently, so that I get the
comma separator, but no decimals.

I can do this easily by modifying the "Comma" style (Format - Style - Comma
- Modify), but when I open a workbook , the style reverts back to the
original format with two decimals.

How can I apply this style change permanently to all workbooks?