The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference.
1. Enter the following values.
2. The Currency format places the dollar sign right next to the number.
3. The Accounting format aligns the dollar signs at the left edge of the cell and displays a dash for zero values.
4. Check the changes in display while using negative numbers between Currency and Accounting.
6,266 total views, 3 views today