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.
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.
HansVogelaar, I've tried creating the Bool.xltx file and saving it to %appdata%\Microsoft\Excel\XLSTART. It was automatically moved into my "Default personal templates location" folder. However, it doesn't appear to be used when I create a new workbook. Any suggestions?
The template should be named Book.xltx, not Bool.xltx
In File Explorer, move the template from your default templates location to %appdata%\Microsoft\Excel\XLSTART
- Sorry, the file name was a typo in my reply, I used the correct file name in the directory. I've manually copied the file to C:\Users\myaccount\AppData\Roaming\Microsoft\Excel\XLSTART\Book.xltx, restarted Excel, but I still get the standard formatting when I create a new workbok
- THANK YOU!
