How to add custom number format to the custom drop down list?

[JenniferMurphy]

Is there a way I can add my own custom number formats to the Custom drop down list in the Number section of the Home tab?

 

[kevin9999]

Is this useful at all:
Number Formats Excel Add-in

 

[JenniferMurphy]

Is this useful at all:
Number Formats Excel Add-in

Looks very interesting. It will take a little study. Thanks

 

[RoryA]

Any custom number format that you use in a file will be added to the bottom of the list when using that file. If you want one available to any new workbook, use it in your book.xltx template.

 

[JenniferMurphy]

Any custom number format that you use in a file will be added to the bottom of the list when using that file. If you want one available to any new workbook, use it in your book.xltx template.

I must not understand something. That's not working for me.

In this sheet, I entered the date in 2 cells. In the second, I changed the format to "m/dd/yy_)". The first one is still "mm/dd/yy".

Book1
	C	D
4	03/27/23	3/27/23
Sheet1

But if I then click the Home tab and then the Custom dropdown in the Number section,

I see this. There is no new format at the bottom of that list.

Am I doing something wrong?

 

[RoryA]

No, I didn't realise you were talking about the number format gallery. I thought you were talking about this list:

I don't know of a way to alter the built-in gallery.

 

[JenniferMurphy]

No, I didn't realise you were talking about the number format gallery. I thought you were talking about this list:
View attachment 88438

I don't know of a way to alter the built-in gallery.

Aha! That custom list. Now I see that my new format is in that list. As you said, it's way down at the bottom. If I were designing the interface, it would be #1, but this is M$FT.

Thanks for clearing that up.