Currency and Accounting formats seem similar but there are little differences which are being cleared in this article.
1. Select values in your worksheet.
As you can see, in accounting format, Excel positions the $ sign on the left edge of the cells and shows a dash for zero values.
Currency vs Accounting Formats
1. Currency format displays a negative number with minus sign in red color with parentheses whereas accounting format displays only negative numbers in parentheses.
2. Currency format places the dollar sign in right front of values whereas, in accounting format, the $ sign positions itself on the left edge of the cells.
3. Currency format shows zero for zero values whereas accounting format shows a dash for zero values.