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
PHPzforward
2024-04-17 15:31:261235browse

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!

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