Home > Software Tutorial > Office Software > Steps to set a number to 10,000 yuan in an Excel cell

Steps to set a number to 10,000 yuan in an Excel cell

PHPz
Release: 2024-04-17 15:31:26
forward
1234 people have browsed it

Have you ever encountered a situation where the numerical unit in an Excel table needs to be displayed as 10,000 yuan? Today, PHP editor Yuzai will introduce in detail the specific steps to set the number to 10,000 yuan to help you easily solve this problem. Please continue reading to make your data display clearer and more professional!

Open the Excel table and set the unit price data in the table to 10,000 yuan.

Steps to set a number to 10,000 yuan in an Excel cell

Press the left button of the mouse to select the cells that need to be set, and then press the right button of the mouse to pop up a drop-down list. Select the [Format Cells] option in the list.

Steps to set a number to 10,000 yuan in an Excel cell

The cell format window pops up, click the number category and select the [Special] option, select [Unit: 10,000 yuan] in the type, and click 10,000 yuan.

Steps to set a number to 10,000 yuan in an Excel cell

Click the [OK] button. At this time, the number of the set cell has been set to 10,000 yuan.

Steps to set a number to 10,000 yuan in an Excel cellSteps to set a number to 10,000 yuan in an Excel cell

The above is the detailed content of Steps to set a number to 10,000 yuan in an Excel cell. 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