what is the difference between excel's currency format and accounting format?
The Currency format places the dollar sign right next to the number. ... The Accounting format aligns the dollar signs at the left edge of the cell and displays a dash for zero values.