Adding Custom Number Categories

[andikins]

Apologies if this has been asked before (I have tried searching)...

What I would like is for
#,##0_);[Red](#,##0)
to appear as an option in the format cell custom number category for
any worksheet that I open - rather than having to type this in each
time I create a new sheet.

Is this possible? If so how?

Cheers!

 

[dziw]

creat an icon linked to a macro that formats the cell as desired
(e-mail address removed)

 

[andikins]

creat an icon linked to a macro that formats the cell as desired

Thanks Olivier

I could do that it's true but I was wondering if there would be a way
of permanently adding formats to the custom number categories - as
there are several formats I would like to use.

Also not sure if the same macro would work for e.g. updating the format
of an item in a pivot table?

 

[andikins]

Can anyone help?

 

[Dave Peterson]

You could try creating a new book.xlt template. Save it in your XLStart
folder. Include all the number formats you want in that workbook.

When you click the new icon on the standard toolbar, excel will use that as the
template for the new workbook.