title: Configure default number format to 0 decimal places for new/existing workbooks in Excel 365 ProPlus?
body: <p>My problem is repeatedly removing decimal places throughout my workday.</p>
  
  <p>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.  </p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>Is there a setting or configuation work around that would do this?</p>
  
  <p>I'm using Excel 365 ProPlus Version 1708.</p>