In Excel, converting the unit of amount from yuan to ten thousand yuan can be achieved by applying a simple formula. Here are the detailed steps:
Apply the formula in a new column: Let's say your amount data is in column A (A1, A2, A3...).You want to display the corresponding amount in 10,000 yuan in column B. Enter the following formula into the first cell (B1) of column b:
=a1/10000Drag and drop the fill: After entering the formula, drag the bottom right corner (fill handle) of cell B1 down to apply the formula to other rows. In this way, each unit amount in column A will be converted to 10,000 units and displayed in the corresponding row in column B.
If you don't want to display the converted amount in the new column, but instead convert the units directly in the original column, you can use Excel's "Paste Special" function.
Select a blank celland enter 10000.
Duplicate this cell（ctrl+c）。
Select your amount data(Let's say a1:a10).
Right-click on the selected area, select Paste Special (or click the Paste Special button in the Paste drop-down menu under the Start tab).
In the pop-up window, select the "Except" action, and then click "OK".
In this way, all the amounts in the selected area will be divided by 10,000, realizing the conversion from yuan to 10,000 yuan.
If you want to keep the original data and display the converted 10,000 yuan data in batches next to it, you can combine method 1 and cell formatting.
Use the formula in Method 1 to batch convert the amount in the new column.
Select the cell containing the converted data, right-click, and select Format Cell.
Under the "Numbers" tab, select "Numbers" and enter the number of digits you want to keep in "Number of decimal places", such as 2 decimal places. You can also add custom number formats in the Type, such as:###0.00 "10,000 yuan", to clearly mark these figures to indicate 10,000 yuan.
The above methods can be selected and used according to your specific needs, and can effectively help you convert the unit of amount from yuan to 10,000 yuan in Excel.