why not create such a style and apply it in the normal way.

or create it an link it to a button

Sub MyMacro()
selection..Style = "MyComma"
End Sub

go to tools = customize
command tab
right window go to Macros
left window, select custom button and drag it to a toolbar.

right click on the button and select assign macro.

assign the above macro. Make other modifications as desired

close the customize dialog.

--
Regards,
Tom Ogilvy


"attaboy" wrote:

Can i create a new toolbar button which will format a cell in a particular
style?

I am trying to create a style similar to "Comma style" but without any
decimal places.