How to change the default number format in Excel?

Question

I have this column of string integers in the 'general' type all the time. Every time I open this spreadsheet, I have to convert it into 'number' type. But when I do it, it automatically creates two decimal points. For example, it changes '12345' to '12345.00'. It's kinds of annoying to use 'Decrease Decimal' every time. Is there any way to make two changes to the default mode? 1) Always assume that the column has 'number' type, not 'general' type 2) To not have any decimal points.

Answer 1

Excel Tips, Learn Excel \ Raghu R

Setting Formatting Options for Workbooks

Excel does not offer many options that allow you to set formatting defaults for your workbooks. However, you can work around this by modifying the formatting in a blank workbook, then saving it as the default template.

1. Open Excel to a blank workbook.
2. Format the blank file with all options desired. For example, set margins, cell color formats, or set up a header or footer. Make sure to remove any values you entered in cells to test formatting unless you want them to appear in every blank workbook.
3. Once your changes are made, click on the File tab and choose Save As.

4. From the “Files of type” drop-down list, select “Excel Template (*.xltx)” and change the file name to “Book.”

5. Set the “Save in” location to theXLSTART folder. This folder is typically located in a path similar to C:Program Files/Microsoft Office/Office14/XLSTART.

   • The quickest way to find its location is to use the Immediate window in the Visual Basic Editor (VBE), as follows:
   • Press Alt+F11 to launch the VBE.
   • If the Immediate window isn’t visible, press Ctrl+G.
   • In the Immediate window, type ? application.StartupPath and press Enter.
   • VBA will display the path to XLStart.
6. Click Save.
7. Quit and re-open Excel. The blank workbook should contain the formatting you previously set.