How to set thousands separator for numerical values ​​in Excel

How to make large amounts of numerical information more readable when using Excel to process data? PHP editor Yuzi will give you the answer! This article will explain in detail how to set the thousands separator for numerical values ​​in Excel to make the data clear at a glance. By understanding this practical technique, you can easily manage and interpret large amounts of digital information and improve your work efficiency. Read on to master this essential Excel skill!

1. Open 2016 e

2. Select the data in the table that needs to set the thousands separator

3 .Press Ctrl 1 and click on the value

4. Find the thousands separator

5. Then repeat in front of the thousands separator Check the box

6. Click OK

7. The thousands separator is set

The above is the detailed content of How to set thousands separator for numerical values ​​in Excel. For more information, please follow other related articles on the PHP Chinese website!