Forum Discussion

Copper Contributor

Nov 02, 2019

Solved

permanently save custom number format

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.

excel

PReagan
Nov 02, 2019
Hello AsthrunLim,

I hope this helps:
https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-put-a-permanent-custom-format-for-time/abe61c12-02e3-478f-964f-d905b7cbe9ce

PReagan

Bronze Contributor

Nov 02, 2019

Hello AsthrunLim,

I hope this helps:

https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-put-a-permanent-custom-format-for-time/abe61c12-02e3-478f-964f-d905b7cbe9ce

AsthrunLim
Copper Contributor
Nov 22, 2019
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.
- PReagan
  Bronze Contributor
  Nov 22, 2019
  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.html
AsthrunLim
Copper Contributor
Nov 09, 2019
PReagan Yes, very thank you for your help.