Formats Monetary (Currency) и Financial (Accounting) in Excel are very similar. This example will demonstrate the difference.
- Enter the following values:
- The currency format adds a dollar sign in front of the number.
- The financial format aligns dollar signs to the left of the cell and displays dashes for null values.
Note: The currency format can display negative numbers with a minus sign, in red, in brackets, or in red in brackets. The financial format displays negative numbers in brackets.