Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to use accounting formatting in Excel

How to use accounting formatting in Excel

Transcript 

In this lesson we'll take a look at the Accounting format. Like the Currency format, the Accounting number format is designed for numbers with currency symbols. The main difference between Currency and Accounting formats is that Accounting aligns currency symbols to the left in each cell, and displays zero values with a hyphen.

Let's take a look.

Let's start off by copying a set of numbers in General format across our table.

Then let's apply Accounting format to the columns C through H. The easiest way to apply Accounting is to use the Number Format menu on the ribbon.

Now let's select cells in column D and check the options available for Accounting in the Format Cells dialog box. Like the Currency format, the Accounting format provides options for decimal places and a currency symbol, and it automatically uses a comma to separate thousandths. Unlike Currency, there are no options for negative numbers. The Accounting format places parentheses around all negative numbers by default.

Let's set decimal places to zero. Like Number and Currency formats, we can also adjust decimal places up and down on the ribbon.

Because parentheses are automatic for negative numbers, there are no options to set in column E.

When it comes to setting the currency symbol for the Accounting format, we have some new options. There are shortcuts on the ribbon for several common currency symbols, and we can use these shortcuts for the British Pound and Euro.

Remember, using these buttons will automatically apply the Accounting number format, if it's not already applied.

To set a currency symbol of None, or to set other currencies, use the Format Cells dialog box.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Your explanation and sharing of how to use INDEX and MATCH on multiple criteria is beyond awesome! I don't have any background knowledge in logic so seeing this illustrated step-by-step enabled me to see those 0 & 1,'s in action for the first time
Josie
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page