Adding Custom Number Categories

  • Thread starter Thread starter andikins
  • Start date Start date
A

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 said:
creat an icon linked to a macro that formats the cell as desired
Click to expand...

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?
 
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.
 
Back
Top