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.
You should read it
- How to separate thousands by commas in Excel
- How to convert dots to commas in Excel on Windows 7
- Convert commas to dots in Excel
- How to convert commas into dots in Excel
- How to get numbers after commas in Excel
- How to Replace Comma with Period in Excel
- How to separate text strings by commas or spaces in Excel
- How to Change a Comma to Dot in Excel
- Instructions for rounding decimal numbers after commas in Excel
- How to display 0 in front of a number in Excel
- How to change commas into dots on Word
- Instructions for searching and replacing in Excel tables