Home>Article>Topics> How to set the unit of ten thousand yuan in excel

How to set the unit of ten thousand yuan in excel

尚
Original
2019-06-12 13:57:51 33090browse

How to set the unit of ten thousand yuan in excel

Select the data in the Excel table that you want to set in ten thousand yuan, right-click and select "Format Cells", select "Number" in the cell format, and select Custom. Enter 0! .0000 (retaining four decimal places), you can set the data unit to 10,000 yuan.

The steps to convert a numerical value into a value in ten thousand yuan in Excel are as follows:

1. Select the data to be set in ten thousand yuan, as shown below :

How to set the unit of ten thousand yuan in excel

2. Right-click and select Format Cell:

How to set the unit of ten thousand yuan in excel

3. Select in Cell Format "Number"

How to set the unit of ten thousand yuan in excel

#4. Click Custom Settings and enter the expression in ten thousand units as indicated by the arrow in the picture below: 0! .0000 (retain four decimal places)

How to set the unit of ten thousand yuan in excel

5. The number unit of the cell in excel is set to 10,000 yuan

How to set the unit of ten thousand yuan in excel

For more Excel-related technical articles, please visit theExcel Basic Tutorialcolumn!

The above is the detailed content of How to set the unit of ten thousand yuan in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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