![merge and center in excel center columnsfor text entering merge and center in excel center columnsfor text entering](https://www.journalofaccountancy.com/content/jofa-home/issues/2020/feb/join-text-in-excel-textjoin-function/_jcr_content/contentSectionArticlePage/article/articleparsys/image.img.jpg)
We can format the number to accounting format either by choosing the accounting option in the Number group or by right-clicking on the menu. In Microsoft Excel, we can find the accounting format under the number formatting group shown in the below screenshot.
#Merge and center in excel center columnsfor text entering how to
How to Use Accounting Number Format in Excel? The difference between Currency and Accounting format is shown in the below screenshot. We can convert the number to accounting format by simply clicking the accounting number format in the number group, and if there are any negative numbers accounting format will display the out in parenthesis $ (500.00) For example, if we format the number to Accounting format, Excel will display the output as $500.00. The Accounting format is also one of the number formattings in excel, which aligns the dollar sign at the left edge of the cell and displays it with two decimal points. We can convert the number to currency format by simply clicking the currency number format in the number group, or we can use the shortcut key as CTRL+SHIFT+$
![merge and center in excel center columnsfor text entering merge and center in excel center columnsfor text entering](https://exceltable.com/en/formatting/images/formatting1-3.png)
For example, if we format the number 500 to currency format, Excel will display the output as $500. The currency format is one of the number formattings in excel, which places the dollar $ sign on the right side to the number. Excel functions, formula, charts, formatting creating excel dashboard & others Difference between Currency and Accounting Number Format in Excel