Buzz
If in a statistical document or calculation, numbers are not separated by commas, it will be difficult for readers to understand the value of those numbers. Follow the instructions below to display thousand separators in Excel 2013 to make it easier for readers to grasp the numbers.Displaying thousand separators in Excel 2013 will help you replace closely spaced numbers with commas separated by thousands, making it easier to calculate numbers and identify data in thousands, millions, billions, etc. The method of displaying commas in Excel, separating thousands, is very simple and you can follow the instructions below.
Display Thousand Separators in Excel 2013
Step 1: Use your mouse to highlight the rows, columns containing numerical data that you want to apply thousand separators in Excel 2013, or you can quickly select all rows, columns containing data by clicking on the column or row headers.
Step 2: Right-click, then choose Format Cells... in the menu that appears.
Step 3: In the Format Cells... window, navigate to the Number option, then check Use 1000 separator (,) to separate thousands in Excel 2013 with commas.
Additionally, you can customize the Decimal places value to display decimal numbers or set it to 0 if you do not want to display decimal points. Then, click OK to save the settings.
After setting up thousand separators in Excel 2013, you will notice that the result is neatly separated numbers, easy to read.
With the guide to displaying thousand separators in Excel 2013 above, you have probably learned an extremely easy way to manipulate numbers, haven't you? If you ever need to display a 0 at the beginning of a number sequence, the guide on how to write 0 in Excel, detailing how to add 0 at the beginning of a number sequence, has also helped you solve this problem. Wish you success!
