- Computers & Software»
- Computer How-Tos & Tutorials
How to add Thousand Separator with numbers in Excel? Process to include Thousand Separator with numbers in Excel cells
We often use Excel with large numbers associated in the process. For the viewers the large numbers might get a bit hard to read, that’s why many of us use Thousand Separator to make it easy for the readers to read. The Thousand Separator is a process to put a comma before the thousandth digit. In this tutorial, we will learn the process to use Thousand Separator in Microsoft Excel 2010 cells.
Steps to include Thousand Separator with number in the Excel cells
To do the process we need to work on a computer which has Microsoft Excel installed in it. Follow the following steps to add Thousand Separator with numbers in Microsoft Excel:
Step 1: Select the entire range of cells which contains the numbers.
Step 2: Right Click on the selected range.
Step 3: From the appeared menu, Click on Format Cells option.
Step 4: Select the Number tab from the appeared box.
Step 5: Select the Numbers option from the category box at selected tab.
Step 6: Tick on the check-box of Use 1000 Separator
Step 7: If you do not want to see any decimal points in the digits of those particular cells, Type down a Zero in the box beside Decimal Points section.
Step 8: Click on OK button from the format cells box.
If you want to keep the decimal points and the digits after it, you can leave the Decimal points section as it is.