- How do you show negative numbers?
- How do you show negative numbers in financial statements?
- How do I change a negative number format?
How do you show negative numbers?
You can display negative numbers by using the minus sign, parentheses, or by applying a red color (with or without parentheses).
How do you show negative numbers in financial statements?
In Accounting, it is common to represent negative numbers with leading and trailing parentheses. For example, (200) equals -200 .
How do I change a negative number format?
Create a Custom Negative Number Format
Start by right-clicking a cell (or range of selected cells) and then clicking the “Format Cells” command. You can also press Ctrl+1. On the “Number” tab, select the “Custom” category on the left. You'll see a list of different custom formats on the right.