ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • 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

Updated on February 11, 2013

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.

Starting the formatting cell process
Starting the formatting cell process

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.

Including the thousand separator from format cells
Including the thousand separator from format cells

Think more

If you want to keep the decimal points and the digits after it, you can leave the Decimal points section as it is.

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.