In Excel, numeric data as you enter regular spreadsheets will not display commas separated by the thousands in them. Adding thousands separators will make your Excel data more visible, intuitive and easy to grasp. Imagine a number of billions without commas separating thousands, then it will be difficult for you to immediately determine what its exact value is causing your time.
How to display thousands separator commas in Excel
When entering data into Excel if the number is up to dozens of digits, you must leave it there show dot or comma delimited unit, dozens, hundreds, thousands, millions… To avoid mistakeness. So how to show thousands separator comma in Excel? Please follow the instructions immediately to find the answer.
How to show thousands separator in Excel
To be able to display commas in Excel on existing numeric data, we need to format that data cell. Here are the steps to make display those commas.
Step 1: Highlight the Cells you want to format
Please highlight any Cells that you want to format, showing thousands commas
Step 2: Open the Fomat Cells dialog box
To open this dialog box, follow these two ways:
From Fomat choose Cell
Or press the key combination Ctrl +1
After opening the Fomat Cells dialog box, set the separator you want. At the card Number you choose Number
Section Decimal places You set to 3, at the item Use 1000 Separator (,) tick this item then click OK, got it
Above, Taimienphi has just guided you how to display thousands separator commas in Excel. It is very simple and easy to read, no matter how large the number, you are not afraid to read them. From now on you can comfortably work with large numbers without worrying about confusion because of the thousands separator. When using Excel you accidentally create spaces, you can delete blank rows and columns in Excel 2013 and you can hide rows and columns of Excel 2013 easily.
In case the number of digits after the comma is too much, you can round it down by referring to the article rounded to decimal after comma in Excel that Taimienphi.vn introduced in previous posts. If you have other methods or tips to show thousands separator in Excel or better, please share with us by comments below this article.