EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Accounting Number Format
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Accounting Number Format

By Karthikeyan SubburamanKarthikeyan Subburaman

Accounting Number Format in Excel

Excel Accounting Number Format (Table of Contents)

  • Accounting Number Format in Excel
  • Difference between Currency and Accounting Number Format in Excel
  • How to use Accounting Number Format in Excel?

Accounting Number Format in Excel

The accounting number format in Excel consists of numbers with the involvement of currency. For example, if you enter the currency name manually with any number manually, the cell value becomes General or Text. And the number of currency cannot be used anywhere. To make that number accountable, click right and select Format Cells and the Accounting section and select the needed currency. We will see, the number will have a currency symbol, and that cell value is still countable in all the financial work.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Difference between Currency and Accounting Number Format in Excel

Currency Format:

The currency format is one of the number formattings in excel, which places the dollar $ sign on the right side to the number. For example, if we format the number 500 to currency format, Excel will display the output as $500. 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+$

Accounting Format:

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. For example, if we format the number to Accounting format, Excel will display the output as $500.00. 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)

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,368 ratings)

The difference between Currency and Accounting format is shown in the below screenshot.

Difference of Currency and Accounting format

How to Use Accounting Number Format in Excel?

In Microsoft Excel, we can find the accounting format under the number formatting group shown in the below screenshot.

Accounting Format under Number Formatting Group

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. We will see both the option in the below example.

Also, we can format the number in accounting format by choosing the dollar sign $ in the number group, which is also one of the shortcuts for the accounting number format shown in the below screenshot.

Dollar Sign $ in Number Group

Example #1

Converting Number to Excel Accounting Format

You can download this Accounting Number Format Excel Template here – Accounting Number Format Excel Template

In this example, we will learn how to convert the normal number to accounting format. Consider the below example, which shows MRP, Selling Price of the individual product with local, national and zonal prices.

Converting Number to Excel

As we can notice that all the numbers are in general format by default, Assume that we need to convert the “Selling Price” to Accounting Number format along with Local, Zonal, and National selling prices.

In order to convert the number to Accounting format, follow the below procedure step by step.

  • First, select the column from E to H, where it contains the product’s selling price, which is shown in the below screenshot.

Selling Price of the Individual Product

  • Now go to the Number group option and click on the drop-down box. In the drop-down list, we can see the Accounting format option.
  • Click on the Accounting number format.

Accounting Format Option

  • Once we choose the Accounting number format, we will get the output as ###, which is shown below.

Output 1

  • We can notice that once we convert the number to accounting number format, excel will align the dollar sign at the left edge of the cell and display with two decimal points that we are getting the ### hash symbols.
  • Enlarge all the columns so that we can see the exact accounting format output, which is shown below.

In the below result, we can see that all the numbers are converted where we can see the Dollar sign$ in each left edge of the cell separated by commas and with two decimal numbers. Output 2

Example #2

Converting Number to Accounting format using Right-Click Menu

In this example, we are going to see how to convert a number using the right-click menu. Consider the same above example, which shows MRP, selling the product with local, national, and zonal prices. We can increase or decrease the decimal places by clicking the “Increase Decimal” and “Decrease Decimal“ icons at the number group.

To apply accounting number formatting, follow the below step by step procedure as follows.

  • First, select the column from E to H, where it contains the product’s selling price, which is shown in the below screenshot.

Selling Price of the Individual Product

  • Now Right-click on the cell so that we will get the below screenshot which is shown below.

Right Click to Format Cells

  • Click on the Format Cells so that we will get the number formatting dialog box which is shown below.

Number Formatting Dialog Box

  • In the above screenshot, we can see the list of number formatting options.
  • Select the Accounting option so that it will display the accounting format, which is shown below.
  • As we can see, on the right-hand side, we can see decimal places where we can increase and decrease the decimal points, and next to that, we can see the symbol drop-down box, which allows us to select which symbol needs to be displayed. (By default, accounting format will select the Dollar Sign $)
  • Once we increase the decimal places, the sample column will display the number with selected decimal numbers which are shown below.

Decimal Place

  • Click the OK button so that the selected selling price column will get converted to Accounting number format, which is shown as a result in the below screenshot.

Accounting Number Format Example 2-5

Example #3

This example shows how to sum the accounting number format by following the below steps.

Consider the example which shows sales data for the month of OCT-18.

Accounting Number Format Example 3-1

As we can see that there are normal sales figures in the General number format. Now we will convert the above sales figure to accounting format for accounting purposes.

  • First, copy the same B column sales figure next to the C column, which is shown below.

Accounting Number Format Example 3-2

  • Now select the C column and go to the number formatting group and choose Accounting, shown below.

Accounting Number Format Example 3-3

  • Once we click on the accounting format, the selected numbers will be converted to Accounting format, shown below.

Accounting Number Format Example 3-4

  • As we can see, the difference that C column has been converted to accounting format with a Dollar sign with two decimal places and at the last column for negative numbers accounting format has shown the number inside the parenthesis.
  • Put the SUM formula in the C13 column, which will show the SUM in accounting format.

Accounting Number Format Example 3-5

In the below result, we can see that the accounting format which automatically uses the dollar sign, decimal places, and comma to separate a thousand figures where we cannot see those in General number format.

Things to Remember 

  • The accounting number format is normally used for financial and accounting purposes.
  • The accounting number format is the best way to configure the values.
  • For negative values accounting format will automatically insert the parenthesis.

Recommended Articles

This has been a guide to Accounting Number Format in Excel. Here we discussed how to use Accounting Number Format along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Numbering in Excel
  2. Auto Numbering in Excel
  3. Excel Date Function
  4. Number Format In Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Accounting Number Format Excel Template

EDUCBA

Download Accounting Number Format Excel Template

EDUCBA

डाउनलोड Accounting Number Format Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more