Learn how to highlight cells with negative values in Excel. Make negative numbers stand out in Red using Conditional or Custom Formatting.

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.

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

Similarly, it's easy to forget to type the currency symbol when you're focusing on the numbers that follow, so using Excel's built-in number format converter is the way forward.