# How to Apply Excel Number Format in Thousands with Comma

We have a dataset of 5 large numbers. We’ll format those numbers in Excel number format in thousands with commas.

### Step 1 – Prepare Your Dataset to Format

• Right-click on the selection.
• Choose the Copy option from the context menu.

• Click on cell C5.
• Right-click and choose the Paste option from the context menu.

### Step 2 – Apply the Excel Number Format in Thousands with Comma

• Select the new column (C5:C9).
• Right-click and choose the Format Cells… option from the context menu.

• The Format Cells window will appear.
• Go to the Number tab and choose the option Number from the Category: pane.
• Tick on the option Use 1000 Separator (,) and choose the option Decimal Places: as 2.
• Choose the first option from the Negative numbers: pane.
• Click on the OK button.

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

## Shorten Numbers to Thousands with Abbreviation K in Excel

Steps:

• Select the cells B5:B9.
• Copy the cells to the adjacent column.

• Paste the values.

• Select cells C5:C9.
• Right-click and choose the Format Cells… option from the context menu.

• The Format Cells window will appear.
• Go to the Number tab here and choose the Custom option from the Category: pane.
• Use the following formula in the Type: text box and click on the OK button.
`#,##0.00, "k"`

You will get the given numbers shortened into thousand with abbreviation K.

## Things to Remember

• You can use Ctrl + C and Ctrl + V to copy and paste cells or ranges, respectively.
• You can open the Format Cells window by pressing Ctrl + 1 rather than using the context menu.

## Related Articles

<< Go Back to How to Add Comma in Excel | Concatenate Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF