WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Comma Style in Excel

Comma Style in Excel

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Comma Style Formatting in Excel

Comma style is a formatting style used in visualizing numbers with commas when the values is over 1000, such as if we use this style on data with value 100000 then the result displayed will be as (100,000), this formatting style can be accessed from the home tab in the number section and click on the 1000 (,) separator which is known as the comma style in excel.

The Comma Style format (also known as the thousands separator) regularly goes with the Accounting format. Like the Accounting position, the Comma arrange embeds commas in bigger numbers to isolate thousands, hundred thousand, millions, and all value considered.

The standard comma style format contains up to two decimal points, a thousand separator, and locks the dollar sign to the extreme left half of the cell. Negative numbers are shown in enclosures. To apply this format in a spreadsheet, feature every single cell and click “Comma Style Format” under formatting choices in excel.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Comma Style format in excel

How to Apply Comma Style in Excel (accounting format)?

You can download this Comma Style Excel Template here – Comma Style Excel Template
  • Enter the values in excel to use the comma number format in excel.

Comma Style excel example 1.1

  • Accounting excel format can be used in the number format ribbon under first, select the amount cell then click on ribbon home and selecting the comma style from the number format column.

Comma Style excel example 1.2

  • Once you clicked on the comma style, it will give you the comma-separated format value.

Comma Style excel example 1.3

  • If you want to remove the decimal, click on to the icon under numbers to decrease decimal

Comma Style excel example 1.4

  • Once you remove the decimal, below you will able to see the value without decimals.

Comma Style excel example 1.5

  • Select cells under Amount column then Right Click on it then choose format cells after that choose accounting option under format cell and if you don’t want the decimal places, put 0 with under decimal places. Click Ok.

Comma Style excel example 1.6

  • Below is the formatted data after removing decimal points.

Comma Style excel example 1.7

Excel Shortcuts to Use Comma Style Format

  • Select the cells which you want to format.

example 2.1

  • Press the Alt key that enables the commands on the Excel ribbon.

excel ribbon example 2.2

  • Press H to select the Home tab in the Excel ribbon, it enables the Home tab of Excel.
  • Press 9 to decrease the decimal and press 0 to increase the decimal point in values.
  • If you want to open the format cells dialogue, press Ctrl+1.
  • If you want to show a monetary value without a currency symbol, you can click None under option format cells.
  • Similar to the Currency format, the Accounting group is utilized for financial qualities. In any case, this arrangement adjusts the decimal purposes of numbers in a section. Likewise, the Accounting design shows zeros as dashes and negative numbers in brackets. Like the Currency organizes, you can determine what number of decimal spots you need and whether to utilize a thousand separator. You can’t change the default show of negative numbers except if you make a custom number organization.

example 2.3

Advantages

  1. It helps you to format the number when you are dealing with currency.
  2. It gives you help in showing the correct value with commas.
  3. It is just one step process.
  4. Very easy and convenient to use.

Disadvantages

  1. It always gives you the number format with a thousand separators.
  2. It gives you the decimal points of two places while using this function.

Things to Remember

  1. Rather than choosing a range of cells, you can likewise tap on the letter over a column to choose the whole column or the number next to a column to select a whole row. You can likewise tap the little box to one side of “A” or above “1” to choose the whole spreadsheet at once.
  2. Always check if you don’t need a comma, remove it.
  3. Decimal is also the user choice if want to put a decimal in values or not.
  4. A custom Excel number format changes just the visual representation, for example how value is shown in a cell. The basic value put away in a cell isn’t changed.
  5. The comma excels format is a default option to show numbers with a comma in the thousands place and include two decimal places (Ex: “13000” becomes “13,000.00). This will also enable to change the visible cell styles in an area of the ribbon so you can easily select different options for comma and display format as required in your sheet.

Recommended Articles

This has been a guide to Comma Style in Excel. Here we discuss how to use comma style format in excel using shortcut keys along with examples and downloadable excel template. You may learn more about excel from the following articles –

  • How to Use Find and Select in Excel?
  • Subscript Excel
  • Superscript Excel
  • Format Phone Numbers in Excel
7 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

WallStreetMojo

Download Comma Style Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More