How to Apply Excel Number Format in Thousands with Comma

Excel is a great tool to handle various types of data. Sometimes, it might occur that you have a dataset of large numbers. Now, for better visualization, it would be better if you use commas in the numbers according to the thousand places. In this article, I will show you all the steps to apply the number format in thousands with comma in Excel.


Download Practice Workbook

You can download our practice workbook from here for free!


Steps to Apply Number Format in Thousands with Comma in Excel

Say, you are given a dataset of 5 large numbers. Now, you need to format those numbers in Excel number format in thousands with commas. Follow the step-by-step guidelines to accomplish this.

Sample Numbers to Apply Excel Number Format in Thousands with Comma


📌 Step 1: Prepare Your Dataset to Format

First and foremost, you have to prepare your dataset for formatting.

  • In order to do this, initially, select your dataset (B5:B9).
  • Afterward, right-click on your mouse.
  • Following, choose the Copy option from the context menu.

Copy Dataset

  • At this time, click on cell C5.
  • Subsequently, right-click on your mouse.
  • Following, choose the Paste option from the context menu.

Paste Dataset

As a result, your dataset is now prepared here to apply formatting without changing the actual given data.

Read More: How to Put Comma after 3 Digits in Excel (7 Useful Methods)


📌 Step 2: Apply Proper Excel Number Format in Thousands with Comma

Now, you will need to apply proper formatting to your dataset.

  • To do this, at the very beginning, select your prepared dataset (C5:C9).
  • Subsequently, right-click on your mouse button.
  • Following, choose the Format Cells… option from the context menu.

Choose Format Cells Option to Apply Excel Number Format in Thousands with Comma

  • As a result, the Format Cells window will appear.
  • Following, go to the Number tab here >> choose the option Number from Category: pane.
  • Subsequently, tick on the option Use 1000 Separator (,) >> choose the option Decimal Places: as 2.
  • Now, choose the first option from the Negative numbers: pane.
  • Finally, click on the OK button.

Excel Format Cells Window to Apply Number Format in Thousands with Comma

Thus, you will get your desired result which would include a thousand separators with commas. And, the outcome should look like this.

Excel Number Format in Thousands with Comma

Read More: How to Put Comma in Numbers in Excel (7 Easy Ways)


Shorten Numbers to Thousands with Abbreviation K in Excel

Moreover,  you can shorten numbers to thousands using the abbreviation K in Excel where K represents thousand. Follow the steps below to achieve this target.

 📌 Steps:

  • First and foremost, select the cells B5:B9 to prepare your dataset from the given dataset.
  • Afterward, right-click on your mouse button.
  • Following, choose the Copy option from the context menu.

Copy Dataset

  • At this time, click on cell C5 and right-click on your mouse.
  • Subsequently, choose the Paste option from the context menu.

Paste Dataset

  • Afterward, select cells C5:C9.
  • Subsequently, right-click on your mouse button.
  • Following, choose the Format Cells… option from the context menu.

Choose Format Cells Option

  • As a result, the Format Cells window will appear.
  • Following, go to the Number tab here >> choose the Custom option from the Category: pane >> write the following formula in the Type: text box >> click on the OK button.
#,##0.00, "k"

Format Cells Window to Shorten Numbers in Thousands with Abbreviation K

Consequently, you will get the given numbers shortened into thousand with abbreviation K. And, the output should look like this.

Shortened Numbers in Thousands with Abbreviation K


💬 Things to Remember

You can open the Format Cells window by pressing Ctrl + 1 rather than using the context menu.


Conclusion

So, in this article, I have shown you step-by-step guidelines to apply Excel number format in thousands with comma. I suggest you read the full article carefully and practice accordingly. I hope you find this article helpful and informative. Besides, you are welcome to comment here if you have any further queries or recommendations regarding this article.

And, visit ExcelDemy to learn about many more Excel problem solutions, tips, and tricks. Thank you!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo