You’ll see the result next time saving a new file, the default type will show as the format you selected. There you will find the option to change the current Locale settings to the correct one. In the ‘Query Options’ dialog choose ‘Data Load’ under ‘Current Workbook’. Choose ‘Query Options’ from the drop down menu. If you want this file can be edited by former versions of Excel, choose Excel 97-2003 Workbook (*.xls).Ĭlick OK to apply the setting to Excel. In the ‘Get & Transform’ section choose the ‘New Query’ option. On the Formats tab in the Region dialog box, click Additional settings. Click on Change the way currency is displayed. Again, results start to display as you type.
#HOW TO CHANGE EXCEL DEFAULT SETTINGS WINDOWS#
In Windows 7, open the Start menu and start typing currency in the search box. Choose the format according to your actual situation. Click on Change the way currency is displayed. As shown in the picture below, the current default format for saving files is Excel Workbook (*.xlsx).Ĭlick the choice box to enable the drop-down list. Find the options of Save files in this format in Save workbooks section. Open any of your Excel files, switch to File tab.Ĭlick saving in in Excel Options window. Repeat the operation for Excel and PowerPoint documents. To avoid repetitive operations, I’d like to share the tip of changing the default format of Excel in case there’s any special situation requires you to save the file in a format other than XLSX every time. Re: How can I change open office default settings In 'My Computer' (or the equivalent under Vista), right-click on any Word document, click on 'Open with.' and 'Choose Program' and in the list select Word, then mark the check box 'Always use this program to open this type of file'. Otherwise it’s necessary to choose a proper format in Save as type before saving the file. If you don’t have any special need to meet, you can let the format stay as default, which is Excel Workbook (*.xlsx), of course. When you create a new Excel file and want to save it for the first time, it can’t be saved directly but requires you to choose the location and format for saving.
0 kommentar(er)
