EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Excel Comma Style
 

Excel Comma Style

Pradeep S
Article byPradeep S
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 21, 2023

Feature Image

 

 

Comma Style in Excel

Comma style is Excel mainly used for numbers to distinguish the different lengths like hundreds, thousands, millions, etc. This allows users to read and spell the numbers incorrectly form. To enable the comma in any cell, select Format Cells from the right-click menu and, from the Number section, check the box of Use 1000 separator (,). We can also use the Home menu ribbons’ Commas Style under the number section. We can even use shortcut keys by pressing ALT + H + K simultaneously to apply comma style.

Comma style format is categorized under the Number format section in the Home tab.

Format Section

Comma style format is also referred to as thousands separator.

This format will prove very helpful when working on a large table of financial sales data (Quarterly, half-yearly, or annual sales data). Here, the Comma style format is applied, enhancing the appearance of numbers. The comma style number format defines the behavior of digits in relation to the thousands, lacks, millions, or billions of digits. Comma Style format offers a good alternative to the Currency format. Comma style format inserts commas in larger numbers to separate thousands, hundred, thousand, millions, billions, and so on.

Comma style is a type of number format where it adds commas to large numbers, adds two decimal places (i.e., 1000 becomes 1,000.00), displays negative values in closed parentheses & represents zeros with a dash (–).

The shortcut key for comma style is ALT + HK.

Shortcut Key

Before working on comma style number format, we need to check whether or not decimal & thousand separators are enabled in Excel. If it is not enabled, we need to enable it & update it by the below-mentioned steps.

  • To check decimals and thousands of separators in Excel, click the File tab.

File Tab

  • Click Options in the list of items on the left-hand side, Excel Options dialog box appears.

Excel Options

  • In the Excel Options dialog box. Click Advanced in the list of items on the left-hand side.
  • Under the editing options, Click or Tick on the Use system separators checkbox if there is no checkmark in the box. The Decimal separator and Thousands separator edit boxes are displayed once you click the “Use system separators” checkbox. Here I selected a comma as the thousands separator and a full point as the decimal separator. After that, click on OK.

Advanced Options

The comma style number format automatically inserts these separators into all the numbers in your workbook.

Different Numeric values or Number types in sales data are as follows.

  • Positive
  • Negative
  • Zero
  • Text

How to Apply Comma Style in Excel?

Let’s check out how comma style number format works on different Numeric values or Number types in Excel.

You can download this Comma Style Excel Template here – Comma Style Excel Template

Comma Style in Excel – Example # 1

In the below-mentioned example, I have monthly sales data of a company, which contains retail, online & vendor sales numbers monthly; in this raw sales data, the appearance of the data is without any number format applied to it.

So, I must apply the comma style number format for these positive sales values.

Comma Style example 1-1

To display sales numbers with comma style format in Excel:

  • Select the cells containing numeric sales values for which I want to display numbers with comma style number format.
  • On the Home tab, you can select the Comma symbol & click on the Comma Style .command in the Number group.

Comma Style example 1-2

; After
Comma Style example 1-3

Once you have clicked on the Comma Style button, you can see the changes in the sales value, where Excel separates the thousands with a comma and adds two decimal places at the end.

In the first cell, you can observe where 7889 becomes 7,889.00. The result is shown below.

Comma Style example 1-4

Comma Style in Excel – Example # 2

In the below-mentioned example, I have monthly sales data of a company, which contains retail, online & vendor sales numbers on a monthly basis. This raw sales data contains both positive & negative values. Currently, the appearance of the sales data is without any number format applied to it.

So, I need to apply comma style number format for these positive & negative values.

Comma Style example 2-1

To display numbers with comma style format in Excel:

  • Select the cells containing numeric sales values for which I want to display numbers with comma style number format. On the Home tab, you can select the comma symbol & click on the Comma Style command in the Number group.

Comma Style example 2-3

  • Once you have clicked the Comma Style button, you can see the changes in the sales value.

Comma Style example 2-4

Where Excel separates the thousands with a comma and adds two decimal places at the end, it encloses negative sales values in a closed pair of parentheses.

Comma Style in Excel – Example # 3

Currently, the appearance of the sales data is without any number format applied to it. In the below-mentioned example, I have monthly sales data of a company, which contains retail, online & vendor sales numbers on a monthly basis. In this raw sales data, it contains both positive & Zero values.

So, I must apply a comma style number format for these positive & Zero values.

Comma Style example 3-1

To display numbers with comma style format in Excel:

  • Select the cells containing numeric sales values for which I want to display numbers with comma style number format. On the Home tab, you can select the comma symbol & click on the Comma Style command in the Number group.

Comma Style example 3-2

Once you have clicked the Comma Style button, you can see the changes in the sales value.

Where excel separates the thousands with a comma and adds two decimal places at the end, and a dash symbol represents zero values.

Comma Style example 3-3

Things to Remember

  • The comma style number Format option in Excel makes your data easier to access & readable; it also helps you to set up your sales data at an industry standard.
  • Apart from various number format options in Excel, you can create your own custom number format based on your choice.

Recommended Articles

This has been a guide to Comma Style in Excel. Here we discussed How to apply Comma Style in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. Excel Date Format
  2. Excel Data Formatting
  3. Merge Cells in Excel
  4. Wrap Text in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Comma Style Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Comma Style Excel Template

EDUCBA

डाउनलोड Comma Style Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW