Buzz
Typically, when working on Excel, numeric data entered won't show thousand separators by default. If you want to display them, you'll need to perform a few steps in Excel to make this happen.
How to Display Thousand Separators in Excel
Displaying Thousand Separators in Excel 2010
In this article, Mytour will use Excel 2010 to demonstrate how to display thousand separators in Excel.
Suppose you have numeric data as shown in the image below and need to format it to display commas for thousand separators.
First, select the cells you want to format to display thousand separators by highlighting them.
Step 2: Open Format Cells for Formatting
To open the Format Cells dialog box, you can follow one of two methods:
- Right-click -> select Format Cells
- Another way is to press the shortcut keys: Ctrl + 1
Step 3: After you open Format Cells -> you set the separator you want. You go to the Number tab -> then choose Number
+ In the Decimal places section, you set it to 3,
+ In the Use 1000 Separator (,) section, you check this box -> then press OK.
As a result, you will see thousand separators appearing in Excel.
The above article just guided you on how to Display thousand separators in Excel 2010 with fairly simple and easy-to-follow steps. Knowing how to display these separators will make your Excel spreadsheet much clearer and easier to understand.
In addition to learning how to display commas in Excel 2010, don't overlook how to display commas in Excel 2013 or 2016, which Mytour has also shared to provide further insight.
