You may have created a datasheet and formatted numbers in Excel. But sometimes you may need to put comma in numbers in your datasheet to comprehend the data easily and make it more reader-friendly. The article will show you how to put comma in numbers in Excel.
In this section, you will find 7 effective and suitable ways for putting commas in numbers in Excel. Let’s check them now!
1. Using Format Cells Option to Put Comma in Numbers in Excel
Let’s say, we have got a dataset of the salesman of a shop and their respective amount of sales (in USD) over a certain period of time.
There is no comma in the numerical value in this dataset. Putting commas make it more reader-friendly as it helps to count the number easily. For putting commas in numbers, proceed with the following steps:
- First of all, select the data> right-click on the mouse> click Format Cells.
- Then, the Format Cells dialogue box will show up. From the Number icon, select Number from Category> Mark Use 1000 Separator> click OK.
- Now, the cell will show the result.
There is a comma after every 3 digits.
- Again, you can also select Accounting from Category> select none from Symbol. This will show the same result.
- Further, you can also select Custom from Category> select #,##0 from the Type box. This will also show the same result (look at the Sample field).
In this way, you can put commas in numbers by using the Format Cells option.
Read More: How to Use Comma in Excel Formula
2. Inserting Comma in Numbers with Accounting Number Format in Excel
For our previous dataset, we want to add commas in numbers by using the Number Format. And for this, follow the steps below:
- Firstly, select data> go to the Home tab> select Number Format> click Accounting.
- Then, the number will be formatted to Accounting separated by commas.
So easy, isn’t it? You can add commas in numbers in the blink of an eye.
Read More: How to Apply Excel Number Format in Thousands with Comma
3. Using Comma Style to Put Comma in Numbers
For our same dataset, now we want to add commas in numbers by using the Comma Style format. Proceed with the following steps for this method:
- First of all, select the data> go to the Home tab> click Comma Style.
- Now, your cells will show the numbers separated by commas.
In this way, you can add commas in numbers by using the Comma-Style format.
Read More: How to Change Comma Style in Excel
4. Use of Shortcut Keys to Put Comma in Numbers in Excel
For the same dataset, we will now show the use of a shortcut key to put comma in numbers.
- Firstly, select the data and press the ALT key.
- Then, the ribbon will show a shortcut key for every option. Press H (for the Home tab).
- Now, the Home tab will be selected. Then press K for Comma Style.
- After that, your cells will show the result.
In this way, you can put commas in numbers by using the shortcut key.
Similar Readings
- How to Put Comma After 2 Digits in Excel
- How to Put Comma After 5 Digits in Excel
- How to Convert Column to Row with Comma in Excel
5. Inserting Comma in Numbers with Excel FIXED Function
We will now use the FIXED function for putting comma in numbers. To apply this method, proceed with the following steps:
- At first, apply the following formula to the selected cell:
=FIXED(C5,0)
Here,
- C5= the actual number
- 0= decimal places (we don’t want any decimal places)
- Then hit ENTER and the cell will show the result.
- Now, use the Fill Handle to drag the formula down the cells.
So, you can put commas in numbers by applying the FIXED function.
Read More: How to Add Thousand Separator in Excel Formula
6. Using Excel TEXT Function to Put Comma in Numbers
Here, we will show the use of the TEXT function for adding commas in numbers. Chase the steps below for applying this function:
- Firstly, select a cell and apply the following formula to the cell:
=TEXT(C5, “#,#”)
Here,
- C5= the actual number
- Now, press ENTER and drag the formula to the down cells to get the output.
So easy steps, isn’t it?
Read More: How to Insert Comma in Excel for Multiple Rows
7. Add Comma in Numbers Using the DOLLAR Function in Excel
If you are dealing with currency in dollar units then you can insert a comma with the DOLLAR function. For adding a comma by applying the DOLLAR function, just follow the steps below:
- Firstly, apply the following formula to the selected cell:
=DOLLAR(C5,0)
Here,
- C5= the actual number
- 0= decimal places (we don’t want any decimal places)
- Now, hit ENTER and use the Fill Handle tool to drag the formula down.
So, these are the steps you can follow for putting commas in numbers in an Excel worksheet.
Download Practice Workbook
Conclusion
In this article, you have learned how to put comma in numbers in Excel. I hope from now on, you will be able to put commas in numbers very easily. If you have any better methods or questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles. Have a great day!
Related Articles
- How to Insert Comma Between Words in Excel
- Add Comma in Excel Between Names
- How to Add Comma Before Text in Excel
- How to Add Comma in Excel at the End
- How to Add a Comma Between City and State in Excel
- How to Change Semicolon to Comma in Excel
- How to Change Comma in Excel to Indian Style
- [Fixed!] Style Comma Not Found in Excel
- How to Remove Commas in Excel
THANKS…, TWAS SOOO… HELPFUL