My problem is repeatedly removing decimal places throughout my workday.
Whenever I change a cell to number format, it defaults to 2 decimal places. 5 becomes 5.00. I then have to Decrease Decimal twice to convert the 5.00 back to 5.
I'm looking for a way to change Excel's settings so that the Number format option defaults to zero decimal places whenever I select Number format any time that I'm working with excel.
I tried the File >> Options >> Advanced menu, 2nd checkbox option to 0 decimal places and this does not work. I am aware of the methods to manually change a cells formatting including number and custom formatting codes. But I do not know how to change the global setting to prevent the issue in the first place.
Is there a setting or configuation work around that would do this?
I'm using Excel 365 ProPlus Version 1708.
Use styles.
Now all cells in your workbook that have been formatted with the Normal style (which is the default), will lose their decimals.
Do this with a new blank workbook and use it as a template for all new workbooks you start or put it in the Excel start folder.