Home Applications How Do You Use the Accounting Number Format in Excel?

How Do You Use the Accounting Number Format in Excel?

by Geek Insider Staff
71 views

If you use excel, you need to learn how to apply the accounting number format for accounting purposes. Below is a guideline on the multiple ways to apply the formatting. 

Is Accounting Number the Same as Currency Format?

The accounting number looks like the currency format, but in the accounting number, the currency sign is placed to the extreme left of the cell, and zeros are displayed as dashes. Also, the accounting numbers format shows negative numbers as a parenthesis. 

The Ribbon Option

  1. Open your Spreadsheet in Excel.
  2. Select the cells with the numbers you want to convert.

Pastedgraphic. Png

  1. Ensure you’re on the “Home” tab in Excel.
  2. Click the “Number” section.
  3. Open the down-arrow next to the “Accounting Number Format” option.

Pastedgraphic_1. Png

  1. Choose your preferred currency. 

Pastedgraphic_2. Png

Your numbers now use the accounting number format.

Pastedgraphic_3. Png

The Format Cells Method 

  1. Open your spreadsheet 
  2. Select cells with numbers.
  3. Right-click one of the cells.
  4. Click “Format Cells.”

Pastedgraphic_4. Png

A new Window will open.

  1. Select “Accounting.”

Pastedgraphic_5. Png

  1. decimal points on the right-side pane through the “Decimal Places” option.

  2. Click the “Symbol” drop-down menu.

Pastedgraphic_6. Png

  1. Now click “Ok.”

All the highlighted cells are now in the accounting number format meaning that you’re ready for accounting tasks in your spreadsheets. 

You may also like

Leave a Comment