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

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

WBOY
Release: 2024-04-25 14:40:23
forward
613 people have browsed it

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!

source:zol.com.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template