If you’re like most people, you probably use Microsoft Excel to keep track of your finances. And if you’re like most people, you probably use the accounting number format to do it. The accounting number format is a simple way to organize your financial data in Excel. You can use it to track your income, expenses, and profits. Here’s how to use the accounting number format in Microsoft Excel:

  1. Open Microsoft Excel and create a new workbook.
  2. Enter the name of your workbook in the “File Name” box and click “Open.”
  3. In the “Workbooks” list on the left side of the window, select your workbook from the list and click “OK.” 4. In the “Sheets” list on the right side of the window, select any sheet from your workbook and click “OK.” 5. On any sheet in your workbook, enter a column heading (for example, “Income”) and start numbering rows 1 through whatever number you want for that column (for example, 1). 6. Enter all of your income data into cells 1 through whatever number you want for that column (for example, 100). 7. Enter all of your expenses data into cells 2 through whatever number you want for that column (for example, 200). 8. Enter all of your profits data into cells 3 through whatever number you want for that column (for example, 300). 9. Click anywhere inside cell 3 and type an equal sign (=) followed by a dollar sign ($). 10. Type a comma followed by an accounting number (such as $100 million), and then press ENTER/RETURN key on your keyboard to finish entering this cell’s information. 11 . Repeat steps 6-10 until all of your columns have been filled in with information about your finances! 12 . To print out a copy of this spreadsheet so that you can keep track of everything ..

If you use Microsoft Excel for accounting purposes, you might want to use the accounting number format for your numbers. There are multiple ways to apply this formatting, and we’ll show how.

RELATED: How to Highlight a Row in Excel Using Conditional Formatting

What Is the Accounting Number Format?

At first glance, the accounting number format looks like the currency format. However, there are a few differences between the two.

Those differences are:

Currency Sign: The accounting number format places the currency sign to the extreme left of the cell. Zeros as Dashes: Your zeros are displayed as dashes in this number format. Negatives in Parentheses: The negative numbers are displayed in () (parentheses). Excel does not do this by default.

All of the methods below let you apply the same accounting number format to your numbers, so use whatever method you find easier to do.

RELATED: How to Change How Excel Displays Negative Numbers

Apply the Accounting Number Format With a Ribbon Option

Excel has an option in its ribbon to help you quickly use the accounting number format in your spreadsheets.

To use it, first, open your spreadsheet with Microsoft Excel. In your spreadsheet, select the cells containing the numbers that you want to turn into accounting numbers.

In Excel’s ribbon at the top, click the “Home” tab.

On the “Home” tab, in the “Number” section, click the down-arrow icon next to the “Accounting Number Format” option.

In the menu that opens, select the currency for your numbers.

And your selected numbers now use the accounting number format.

You’re all set.

RELATED: How to Add New Buttons to the Microsoft Office Ribbon

Apply the Accounting Number Format With a Drop-Down Menu

Another way to apply the accounting number format is to use the number formatting drop-down menu.

To use this method, open your spreadsheet with Microsoft Excel. Then select the cells with numbers in them.

In Excel’s ribbon at the top, click the “Home” tab.

On the “Home” tab, in the “Number” section, click the drop-down menu.

From the drop-down menu, choose “Accounting.”

And all your selected numbers are now in the accounting number format.

That’s it.

RELATED: How to Create Expense and Income Spreadsheets in Microsoft Excel

Use Accounting Numbers With the Format Cells Window

The third way to use the accounting number format in Excel is by opening the Format Cells window.

To do that, open your spreadsheet and select the cells with the numbers in them. Right-click one of these cells and select “Format Cells” from the menu.

A “Format Cells” window will open. Here, from the “Category” list on the left, select “Accounting.”

In the pane on the right, specify decimal points for your numbers using the “Decimal Places” option. Then, choose a currency from the “Symbol” drop-down menu.

Finally, click “OK” at the bottom of the window.

Your chosen cells are now formatted in the accounting number format.

You’re now ready for your accounting tasks in your Excel spreadsheets.

Does Excel remove the zero from the beginning of your numbers? There’s a way to make it keep those zeros.

RELATED: How to Enter Zero Before a Number in Excel