how can I change the number format for all new excel workbooks?

Dear respected Theeloneous,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, to change the number format for all new Excel workbooks, you need to modify the default template used by Excel. By customizing the default workbook template, any new workbook you create will automatically inherit the desired number format.

Here are the steps to customize the default number format:

1.Open a new blank workbook in Excel.

2.Format a cell with the desired number format as per your preference.

4.In the "Save As" dialog box, navigate to the Excel templates folder. Look for XLStart folders.

5.In the "Save As" dialog box, change the "Save as type" to "Excel Template (.xltx).

For your reference: Save cell styles to use in all new workbooks

We appreciate your understanding that sometimes the initial suggestions may not resolve the problem very soon. However, we can work together to narrow down and resolve the situation.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Hi respected Theeloneous,

I'm writing a follow up this case, and I haven’t received any information from you, may I know have you checked above reply? Feel free to post back if you need further assistance.

Have a good day and stay safe 😊

Sincerely,

Waqas Muhammad

Thank you Waqas. I was unable to find the XLStart folder, even by doing a word search for it. Can you advise where I might be able to locate it?

Thank you so much!

Rob

Hi respected Theeloneous,

Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

And I appreciate your kind words.

Try the following into the address bar of File Explorer (replacing what's there):

%appdata%\microsoft\excel\xlstart

and press Enter.

Also, it's possible to set an alternative startup location.

In Excel select File>Options>Advanced and scroll down to the General section> "At startup, open all files in".

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad

Hi respected Theeloneous,

I'm writing a follow up this case, and I haven’t received any information from you, Feel free to post back if you need further assistance.

Have a good day and stay safe 😊

Sincerely,

Waqas Muhammad

Dear

Not sure of your desired format but
Just change your regional settings

HTH
Regards

JY