Feb 2nd, 2011, 12:51 PM #5, re: Setting excel Default Number Format - Excel 2010.
Default sheet template folder default used when creating template a new blank excel sheet.Then use File Explorer to copy folder the Sheet.Again, confirming the startup folder can be tricky, depending on whether you have Excel 2011 or 2016 installed default (2008 not tested).Feb 2nd, 2011, 01:19 PM #7, re: Setting Default Number Format - Excel 2010.Create a Default Workbook Template, open a new workbook.That folder way, you can immediately see if your custom template is being used. Data validation settings, macros, hyperlinks switches and ActiveX controls, workbook calculation options.
You can try saving to the xlstart folder though Excel may tell you basara dont have Administrator access.
2 decimal places, in Excel 2010?
Default switches workbook template used when creating a new switches blank workbook.Feb 2nd, switches 2011, 11:22 AM #2, re: Setting Default Number Format basara - Excel 2010.Both answers are extremely helpful.Once you have created a template it is easy to share with other people.Test to be sure Excel is using the template when new workbooks are created * Based on comments seeds below, it seems the name of your workbook must be localized for your version of Excel.You need to close and re-open Excel for the new default workbook template to take effect.If you get frustrated and can't make things work, you can set your own startup folder manually, as described below.