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.
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).
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.