How to Display Thousands Separator Commas in Excel

This updated guide explains how to Display Thousands Separator Commas in Excel through clear steps, practical examples, and important checks that help prevent common errors.

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

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

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

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

You see the results below:

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.