Favourite numeric format

[jdmaybee]

I like the custom numeric format #,###.00_);[RED](#,###.00);0.00

Is there any way I can set this up on my toolbar like the , format?

 

[Hui]

In 2007/10 you can add a custom button to the Ribbon/QAT and apply a macro to it


The macro will be as simple as

[pre]

Sub MyFormat()
Selection.NumberFormat = "#,###.00_);[Red](#,###.00);0.00"
End Sub

[/pre]
Copy the above macro to a code sheet in your personal.xlsx file


To add a macro

Right Click on QAT

Customize Quick Access Toolbar

Choose Commands from Macros

Find your Macro "MyFormat"

Add >>

Move up/down to suit

Select Modify and apply a new icon to your macro


Enjoy