permanently save custom number format

[AsthrunLim]

Hi, everyone. want to get help on how i can permanently save custom number format in excel so that i can use the number format that created in every newly open excel file, tq.

[#2 · Accepted solution]

Hello @AsthrunLim,

I hope this helps:

https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-put-a-permanent-custom-format-for-t...

[#3]

@PReagan Yes, very thank you for your help.

[#4]

Hello, @PReagan .

I again, after using yours ways, it work for me, but i have a new question that is if got any ways to apply the settings/format created for previous excel file that created before?

Thank you.

[#5]

@AsthrunLim 

For this, I would suggest using the format painter or maybe the following would help.

https://www.extendoffice.com/documents/excel/2518-excel-apply-template-to-existing-chart-workbook.ht...