Question: what is the difference between excel's currency format and accounting format?
Answer: 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.