Excel - make accounting, currency, and number style zero decimal places by default

Posted on:  01/18/2017
Excel - make accounting, currency, and number style zero decimal places by default

Microsoft Excel has the number group on the Home tab that is frequently used. The number group has five commands on the bottom row. Going from left to right the commands are Accounting Number format, Percent Style, Comma Style, Increase decimal, and decrease decimal.

  1. Accounting Number format
  2. Percent Style
  3. Comma Style
  4. Increase decimal
  5. Decrease decimal

Using Accounting and Comma, the default decimal places are two decimal places. Example: 125.35 and 435,903.93.

When dealing with a lot of large numbers it is common to lose the decimal places. Instead of manually losing the two decimal places with decrease decimal, you can change your setting in the control panel to show zero decimal places by default.

Excel numbers group

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories