The default settings for the accounting number format, which is one of 10 formatting choices in Excel, are to include two decimal places in the number entered into the spreadsheet and to display ...

Learn how to format & display Currency in Excel to display numbers as monetary values, by applying Currency or Accounting number format to cells.

However, the Accounting number format displays zeros as a dash, making those cells easier to distinguish from positive or negative values in a large accounting spreadsheet.

Using Excel's number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how you want it to. In this article, I'll explain what each number format ...