Skip to content

How to Apply Accounting Number Format in Excel – 2022

The accounting number format describes what a number refers to. For example, 100 dollars is represented by its currency symbol $100.

Similarly, you can convert the numbers into the format of your choice. They are General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific, Text, Etc.

Applying Accounting Number Format

Select the number or range of cells that you want to change

Select the Range of cells with or without numbers
Select the range of cells with or without numbers

On the Home tab, click the dialogue launcher arrow of the “Number” as in the picture below.

In the dialogue box, select “Accounting”.

Under “Sample”, choose the decimal places for the numbers, or keep it as it is because the default decimal places are 2 which are used frequently.

Lastly, select one of the currency formats, based on your country. After that click OK.

Apply accounting number format in Excel
Apply accounting number format in Excel

Now automatically the number format will be applied to the range of cells that contain numbers. Or, type the number in a selected range to change it to format if you have not kept the numbers in range.

Currency number format in excel
Currency number format in excel

2. Currency Format

After selecting the number or range of cells that you want, do the following:

Right-click on the numbers, or cells that you have selected.

Select “Format cells” to open a dialogue box.

Formatting cells
Formatting Cells

In the dialogue box, select “Accounting”.

Under “Sample”, choose the decimal places for the numbers, or keep it as it is because the default decimal places are 2 which are used frequently.

Lastly, select one of the currency formats, based on your country. After that click OK.

3. Add Currency Symbol to the Number

After selecting the number or range of cells that you want

Click “More number formats” after clicking “General” in in “Number” group, on the “Home” tab.

More Number Formats
More Number Formats

In the dialogue box, select “Accounting”.

Under “Sample”, choose the decimal places for the numbers, or keep it as it is because the default decimal places are 2 which are used frequently.

Lastly, select one of the formats, based on your country. After that click OK to How to Apply Accounting Number Format in Excel.

What is the usage of Currency Number Format in Excel?

These are useful for monetary values that are related to money or currency.

Share