How to deal with the sum of money symbols and numbers

1.

Reason: the currency symbol in front of the number is another input character, not a numerical format, so the summary operation cannot be performed

solution:

1. First, input the data content with currency symbol in Excel

2. It's OK to remove the symbol of euro. There are words and symbols after the number (front and middle). The system does not calculate them
you can set the cell format to currency format, and you can select the required currency symbol, so that the value can be calculated.

3. Just make the format regular, or replace the RMB symbol with blank by searching and replacing. Is your form manual? You can change the cell format to the one with RMB symbol after summation.

4. Can not participate in the calculation of the number, because excel as the number of text and ignore. However, for some pasted numbers, it is not necessarily effective to select the batch of numbers and set the cells in a conventional way at one time. However, double-click each cell once can be effective. For such things, you can have a function, or a number 1, select paste, calculate, multiply, to solve. try,

5.

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:

6. If the currency symbol is added to the "currency" format in Excel, it can be directly summed
if it is added manually and cannot be operated by operator, the following method can be used:
suppose there are two such numbers in A1 and A2 lattices, and when adding:
= right (A1, len (A1) - 1) + right (A2, len (A2) - 1)

7. The number in Excel table can't be summated, which is expressed as text format. Select the cell range, click the exclamation button in the upper left corner, and select "convert to number"