Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Converting Numbers into Accounting in Excel

February 24, 2016 by Tyrone Pernsley

If you’ve ever wondered why there is an accounting format in Excel when there is already a currency format than you are not alone.

Creating excel spreadsheets that contain currency like an income statement or a balance sheet can be difficult to organize. Sometimes the numbers, decimal places and dollar signs do not line up, making the spreadsheet look confusing.

For this reason, the accounting format was created.

Currency vs Accounting screenshot

This format is very similar to the currency format. The only differences that make this format easier for accounting are:

  • It shows zero values as dashes
  • Aligns all the currency symbols and decimal places
  • Shows negative numbers in parentheses.

Here is how to navigate the accounting format in excel.

#10 gif

To convert numerical cell values to the accounting format simply highlight the desired cells and right click them. Then:

  • Click the Format Cells option
  • Click the Number category
  • Choose the accounting tab – this will give you the option to change how many decimals points or which type of currency symbols you desire to show.
  • Click OK and bam, it is now in the accounting format!

To format empty cells, highlight the desired cells and right click them. Then:

  • Click the Format Cells option
  • Click the Number category, and then chose the accounting tab.
  • Click OK and start to enter the numbers you desire.

The numbers you input will be automatically converted to the accounting. Looks neat and clean, right!?

If you would like to convert any cells back to normal numbers, simply highlight the desired cells and right click them, click the Format Cells option, click the Number category, and then chose the general tab.

We hope you found today’s quick and easy Excel lesson beneficial. Don’t forget to follow us on Social Media and subscribe to the blog to get convenient, quick tips like this, and other great Excel training tips so that you can take the fear out of Excel.

Like Learn Excel Now? Sign up for the newsletter!

-Kevin, Learn Excel Now

Comments

  1. Vic says

    February 24, 2016 at 9:44 pm

    Good material. Learned something new.

    • Kevin Erdman says

      February 25, 2016 at 8:52 am

      Hi Vic, glad to hear it. Thanks for sharing.

  2. renee says

    February 26, 2016 at 6:41 am

    learned something new – thanks

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In