1. Select the area of planning data;
2. Right-click to select; In the pop-up menu, click Cell Format.
3. In the pop-up operation box, click "Custom"; Then, in the edit box under Type on the right, add a unit or character after the original "G/ Universal Format", such as adding a word "yuan"; Click OK again;
4. After the point is determined. And then inputting data in a predetermined data area; Every time you enter a piece of data, the word "yuan" you set will be automatically attached to the data.
5. Select C 1 to C 12, then enter: = A 1 * B 1 in the edit field, and press CTRL and ENTER. That is, the corresponding results are obtained. This solves the problem of how to bring unit calculation in EXCEL.