The number in Excel can't be summated with currency symbol
Publish: 2021-05-28 22:10:42
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.
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.
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
4.
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:
5. 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)
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)
6. Often go to the foot bath man, as long as it is to go to the formal foot bath place, is also trustworthy.
7. Yes, I can still see the gold coin icon slowly turning yellow when I read it now. When the Yellow turns full, I will be prompted to read 10 more gold coins to the account
8. Money saving express can make money by reading, consulting, watching videos, etc. the gold coin earned will be automatically converted into cash every day, which is very convenient.
Hot content