How to display thousands separator commas in Excel

You often have to work with Excel, enter data for Excel and calculate and process them. Small numbers are easy to read, but large numbers over ten digits are hard to read.

How to display thousands separator commas in Excel Picture 1

You want to display the comma delimited thousands for easy reading. Here's how you can show thousands separator commas in Excel.

How to display thousands separator commas in Excel Picture 2

Step 1: Highlight Cells that need to display the thousands separator in Excel.

How to display thousands separator commas in Excel Picture 3

Step 2: Right-click and select Format Cells (or Ctrl + 1 key combination ).

How to display thousands separator commas in Excel Picture 4

Step 3: In the Format Cells select the Number tab Number , then tick the box before the Use 1000 Separator (,) and press OK .

How to display thousands separator commas in Excel Picture 5

You see the results below:

How to display thousands separator commas in Excel Picture 6

With the above steps, you can display thousands comma separated in Excel. It is very simple and easy to read, no matter how large the number, you don't mind reading them. From now on you can comfortably work with large numbers without worrying about confusion because of the thousands separator.