Xlsx number preceded by currency symbol

1. This is the currency format of Excel. To remove it, just follow the following steps:
select these cells → format → cells → numbers → general (or numerical value, and specify decimal places) → OK
if you don't set the currency format, ￥ is entered manually, you can use the method above.

2. Set the cell format, change #, #, 0.00 to #, #, 0.00 ￥ in user-defined, and then set the cell to this format

3.

Select area - right click - set cell format - switch to number tab - select value by category - select negative number format - OK, as shown in the figure:

4. Insert - select the symbol you want in the symbol. Double click it. If there is no insert - symbol, select Insert - special symbol. There must be some.

5.

The operation method of adding currency symbol to cells in excel is as follows:

1. first, select cells (such as m54), right-click the cell range, and select "set cell format"

2. next, click "number" -- "currency", select the corresponding currency symbol, such as "￥", and then click "OK"

   

3. finally, click "OK"< br />

6.

"￥" does not need to input

to select the format

7. Click the cell with symbol, right-click, select custom in the number option, and click "delete" at the bottom of the box

8. Right click the cell, set cell format, select currency, and select RMB symbol in currency symbol (country / region) on the right.

9.

If A1: A13 is a number with RMB symbol (in fact, it is already text), then enter the formula = superproct (- - substitute (A1: A23, & quot; ￥",)) That is to sum. See the figure below:

10. That symbol is just a display format, does not affect the calculation of the!!!