Currency v/s Accounting


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.

7,917 total views, 11 views today

One thought on “Currency v/s Accounting

  1. Hi,

    Nice information.

    Can you please tell us when to use Currency symbol and when to use Accountng? What is the significance of each of them and how they are different from each other?

    Thanks and keep posting such informative articles.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>