Forum Discussion
Can you change the default comma number format to exclude decimals?
Comma is a style. You can modify this style to have 0 decimal places.
On the Home tab of the ribbon, click Cell Styles, then right-click Comma.
Select Modify..., then click Format...
Change Decimal places to 0, then cick OK.
This will apply to the active workbook only.
But you can create a new workbook, modify the Comma style as described, then save the workbook as an Excel template named Book.xltx in your startup folder for Excel - by default %appdata%\Microsoft\Excel\XLSTART. The name Book.xltx is obligatory (but it depends on the language).
It will then be used when you start Excel, and also when you create a new workbook by pressing Ctrl+N or by clicking New on the Quick Access Toolbar.
How do you create a new workbook?
That won't work. Excel should use Book.xltx when you
- Start Excel.
- Press Ctrl+N to create a new workbook.
- Click the New button on the Quick Access Toolbar (if you have this button).
- Interesting - it works when I use Ctrl + N once I am viewing a workbook (new or existing). Is there any way to control the template used when you select the "Blank workbook" from the File tab? It seems odd that these two options behave differently
As far as I know, there is no way to make File > New > Blank Workbook use Book.xltx. It opens some kind of factory-default template.