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 :
2. Right-click and select Format Cell:
3. Select in Cell Format "Number"
#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)
5. The number unit of the cell in excel is set to 10,000 yuan
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!