Home  >  Article  >  Software Tutorial  >  How to set thousands separator for numerical values ​​in Excel

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

WBOY
WBOYforward
2024-04-25 14:40:23569browse

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

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

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

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

3 .Press Ctrl 1 and click on the value

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

4. Find the thousands separator

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

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

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

6. Click OK

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

7. The thousands separator is set

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

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete