How to retain tens of thousands of values in Excel: First open the Excel table to enter data and select the data; then select the data and right-click the mouse and select Set Cell Format; then click Custom and enter [in the type] 0"."0000"万元"]; Finally, click [Confirm].
How to retain the tens of thousands of values in excel:
1. Open the Excel table, then enter the data, and Select the data.
#2. After selecting the data, right-click the mouse and select Format Cells, or press the shortcut Ctrl 1.
#3. Enter the cell format setting page, click Customize, enter 0"."0000"万元" in the type, and then click OK.
#4. After determining the cell format, the value will automatically become the format of 10,000 yuan.
Related learning recommendations:excel basic tutorial
The above is the detailed content of How to retain tens of thousands of values in excel. For more information, please follow other related articles on the PHP Chinese website!