How to Simultaneously Apply Accounting Number Format in Excel

This article illustrates how to apply accounting number format in excel simultaneously. This is a very wildly used number formatting in excel. Unlike the currency format, it aligns the currency signs ($) column-wise and shows negative numbers inside brackets. If you work with currency or sales, then you will often need to apply the accounting number formatting to multiple ranges simultaneously. Follow the article to learn how to easily do that in excel.


Download Practice Workbook

You can download the practice workbook from the download button below.


Steps to Apply Accounting Number Format Simultaneously in Excel

Follow the steps below to be able to apply the accounting number format simultaneously in excel.

📌 Step 1: Organize Data

  • Assume you have the following dataset. Here you need the Sales and Amount columns to be formatted in the accounting number format. The following steps will enable you to do that.


📌 Step 2: Select Data & Apply Formatting

  • First, select the range C5:C10. Then click on the $ sign in the Number group from the Home tab.

apply accounting number format in excel

  • After that, you will see the following result. You can choose a different currency from the dropdown arrow beside the $ sign.
  • Now you can select the range E5:E10 and repeat the same procedure to get a similar result.


📌 Step 3: Select Multiple Ranges

  • Alternatively, you can apply the accounting number format to both columns simultaneously by selecting them at first. Select range C5:C10, hold the CTRL key, and then select the range E5:E10. This way you will be able to select both columns.

Read More: Apply the Accounting Number Format to the Selected Cells in Excel


📌 Step 4: Apply Accounting Number Format

  • Now, click on the dropdown arrow beside the General number format in the Number group from the Home Next, choose the Accounting number format.

apply accounting number format in excel

  • Alternatively, you can click on More Number Formats or press CTRL+1 to open the Format Cells dialog box.
  • Then, select the Accounting category from the Number tab. Next, fix the decimal places as required and choose the proper currency. Finally, click OK.

apply accounting number format in excel

  • After that, you will see the following result. You can also use the ALT+H+AN+Enter shortcut for that.

Read More: [Fixed] Accounting Format in Excel Not Working (2 Quick Solutions)


Things to Remember

  • You need to hold CTRL to select multiple ranges to apply the accounting number format simultaneously to them.
  • You can format the data ranges as accounting number format even before entering any data. This way whenever you enter the numbers, they will be formatted automatically.

Conclusion

Now you know how to apply accounting number format simultaneously in excel. Do you have any further queries or suggestions? Please let us know using the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo