How to retain tens of thousands of values ​​in excel

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!