• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to Apply Accounting Number Format in Excel

0 Comments

When using Microsoft Excel for accounting purposes, it is often helpful to convert numbers from the standard number format to the accounting number format. The accounting number format adds the currency symbol to the left of the cell, includes thousand number separators, and displays two decimal places at the end of each number. In addition, the accounting number format replaces a zero value with a dash “-“.How to Apply Accounting Number Format in Excel 1

There are several ways to apply the accounting number format in Excel:

Method 1: Apply Accounting Number Format Using Accounting Number Format Button

  1. Select the cells or range with the numbers you want to format.
  2. Go to the “Home” tab and click on the “Accounting Number Format” button.
  3. Choose the accounting format with the desired currency symbol from the drop-down list.How to Apply Accounting Number Format in Excel 2

The selected cells or range will now display the accounting number format with the chosen currency symbol, thousand number separators, and two decimal places.How to Apply Accounting Number Format in Excel 3

To adjust the number of decimal places, use the increase and decrease icons under the “Number” group on the ribbon.How to Apply Accounting Number Format in Excel 4

Method 2: Apply Accounting Number Format Using the Drop-Down in the Number Group

  1. Select the cells or range with the numbers you want to format.
  2. Go to the “Home” tab and click on the drop-down arrow under the “Number” group on the ribbon.How to Apply Accounting Number Format in Excel 5
  3. Choose the “Accounting” option from the drop-down list.How to Apply Accounting Number Format in Excel 6

The selected cells or range will now display the accounting number format with the default currency symbol of your system.How to Apply Accounting Number Format in Excel 7

Note that you cannot choose a specific currency symbol using this method.

Method 3: Apply Accounting Number Format Using the Format Cells Option

  1. Select the cells or range with the numbers you want to format, and then right-click on your selection.
  2. Select the “Format Cells” option from the drop-down menu to open the “Format Cells” dialog box.How to Apply Accounting Number Format in Excel 7
  3. Choose the “Number” tab and select the “Accounting” option under the “Category”.
  4. Click on the “Symbol” drop-down arrow and choose the desired currency symbol from the options.
  5. Use the “Decimal Places” up and down arrows to adjust the number of decimal places.
  6. Click OK.How to Apply Accounting Number Format in Excel 9

The selected cells or range will now display the accounting number format with the chosen currency symbol, thousand number separators, and two decimal places.How to Apply Accounting Number Format in Excel 10

By following these simple steps, users can easily apply the accounting number format to their data sets in Excel, making them more suitable and clear for accounting purposes.

Rate this post
21
264 Views
How to Use Find and Replace in ExcelPrevHow to Use Find and Replace in ExcelApril 26, 2023
Count Non-Zero Cells in Excel using COUNTIFApril 26, 2023Count Non-Zero Cells in Excel using COUNTIFNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Windows Server 2025 Remote Desktop Services 50 User Connections Windows Server 2025 Remote Desktop Services 50 User Connections $25.00
  • Project Professional 2021 Microsoft Project Professional 2021 - 1 PC $13.00
  • Windows Server 2025 Standard Windows Server 2025 Standard $30.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Microsoft Visual Studio Enterprise 2019 For 1 PC Microsoft Visual Studio Enterprise 2019 For 1 PC
    Rated 4.88 out of 5
    $15.00
  • Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 4.72 out of 5
    $20.00
  • Microsoft Office Home And Business 2019 CD Key for MAC Global Microsoft Office Home And Business 2019 CD Key for MAC Global
    Rated 4.95 out of 5
    $30.00
  • Kaspersky Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • Microsoft Visual Studio Enterprise 2022 For 1 PC Microsoft Visual Studio Enterprise 2022 For 1 PC $19.00
  • Windows 10 Pro Key Global 20 PC Windows 10 Pro Key Global 20 PC $50.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

00Hours00Minutes00Seconds
Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.

BESbswyBESbswyBESbswyBESbswyBESbswyBESbswyBESbswyBESbswy