Cloud Training (Online)




Currency vs Accounting Format in Excel

This article is all about Currency format and Accounting format in Microsoft Excel. You’ll get to know about the differences between them and also how to implement them.

What is the Currency and Accounting Format?

Currency Format in Excel displays the value entered in the form of dollars.
Accounting format also displays the data in the form of dollars.

Difference between the Currency format and Accounting format

The difference between these two formats even though these two display the same format is that the currency format displays the dollar sign right next to the number i.e, for example, $27.
Whereas the accounting format displays the dollar symbol at the start of the cell, i.e the left corner but the numbers stay put in the right corner as usual.


Below is the screenshot of Currency format.

Currency vs Accounting Format in Excel

Below is the screenshot of Accounting format.

Currency vs Accounting Format in Excel

How to implement the Currency format and Accounting format?

  • Select the cell you want to format.
  • Open the Format dialog box by right-clicking on the cell and selecting format cells options or use Ctrl+1 or click on the arrow in the bottom right corner of the number group in the Menu tab.
  • Once the format dialog box opens up go to Currency or Accounting format under the Number tab in Categories.
Currency vs Accounting Format in Excel
  • Currency format offers more than one format and the Accounting format offers only one format.

Currency format –

Currency vs Accounting Format in Excel

Accounting format –

Currency vs Accounting Format in Excel
  • After deciding your format click on OK to save the changes you made.
Currency vs Accounting Format in Excel


Then the changes you made will be displayed.


Currency vs Accounting Format in Excel


We hope by this you understood the differences between Currency and Accounting format and how to implement it.