Table currency format number sum

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

1. First, open the table to be set on the computer, click the letter at the top of the cell, and select the whole column

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:

If the currency symbol is a Chinese character, the cell becomes text format, so it cannot be summed. So we need to replace Chinese characters with English characters. The symbols of d5 and D7 in the figure below are different. D7 is a Chinese character and cannot be calculated