While processing data in Excel, we may need to type some long numbers in Excel cells. As we all know, a long number can be very easily mistaken. So can we add thousands separators to make them more intuitive?
The method is quite simple.
1. Select the data that you want to insert thousands separators and press Ctrl+1.
2. Or you can right-click the selected area and choose Format Cells…
3. The Format Cells window will then pop out. Choose Number in the list of Category and check Use(,)
4. Hit OK. You can see the thousands separators have been added to the numbers in selected cells.