Hi Ken,

Alt-F11 to enter the VBE
Insert | Module
Paste the following code:

'===========
Public Sub aTester()
Selection.NumberFormat = "#,##0_);[Red](#,##0)"
End Sub
'<<===========

Alt=F11 to return to Excel

View | Toolbars | Customize | Select 'Commands' tab
Select 'Macros' in the left-hand Categories window
Drag the smiley icon ftom the commands window to your toolbar
Right-click the smiley | Assign Macro
Enter (or select) the name of your macro
OK | Close

Change the macro's number format to your required format.

Change the macro name to suit.

---
Regards,
Norman



"Ken G." wrote in message
...
I'd like to create a toolbar button linked to a custom number format so
that
clicking on the button would re-format the active cell or range to my
custom
format.