how to apply accounting number format in excel ?-In This, We Are Going To See About  Format Numbers In Excel

How to Apply Accounting Number  Format in Excel?

In Microsoft Excel 2010, the accounting format is quite similar to the currency format in that both show the currency symbol next to each number. However, the accounting style differs in a few ways that make accounting easier, such as displaying zero values as dashes, aligning all currency symbols and decimal digits, and displaying negative numbers in parenthesis.

1.Open the Excel 2010 file you want to modify the format of.

2.In the range of cells you want to shift to the accounting format, select the top-left cell. You can see the bottom-right cell of your selected range by scrolling the spreadsheet using the scroll bars on the right and bottom corners. To select the full range, hold “Shift” and click this cell.

3.Choose “Format Cells” from the pop-up menu when you right-click anywhere inside your selected range.

4.From the list on the left side of the window that displays, select “Accounting.” Choose your currency symbol from the drop-down menu in the center of the window, then adjust the number of decimal places shown with the up and down arrows.

5.To exit the window, click “OK,” and the numbers in your selected range will now be displayed in accounting format.

How to Apply Accounting Number Format in Excel! (Easy way)

The Accounting format is similar to the Currency Format in that it can be used with numbers. The Accounting format differs from the Currency format in that the Accounting format, for example, places the dollar sign at the far left end of the cell and displays zero as a dash. So, let’s have a look at a basic example to see how to use Excel’s Accounting number format.

As depicted below, an accountant at a fictitious accounting business is putting together a spreadsheet to track the value of fixed assets for the current financial year.

In Excel, how do you use the accounting number format?

1) To apply the Accounting format, right-click the range and select Format Cells from the drop-down menu.

2) Select Accounting from the Format Cells Dialog box’s Number Tab, accept the parameters indicated below, and click Ok.

3) The Accounting Format is used in this case.

Format numbers as currency

You must format numbers as currency if you want them to be displayed as monetary values. To do so, select the Currency or Accounting number format and apply it to the cells you want to format. The number formatting options are found under the Number group on the Home tab.


Using Excel to apply the Accounting format is simple and uncomplicated. The Accounting format can be used to create financial statements, balance sheets, and other accounting-related documents.

Please feel free to leave a comment and inform us about the spreadsheet types you use.

Categorized in: