Work, you have to learn to deal with 12 excel problem _ China accounting perspective network _ is required accountants - CPA | Certified Tax | Accounting titles | Senior Accountant | Accounting practitioners

The most frequently encountered in the work of 12 problem. If you feel useful, be sure to remember Enjoy your friends * _ *. Problem: When sum is summed, it is found that the result is 0 or some numbers are not involved in the calculation. Solution: can not calculate the general there are two cases: First, the number is the text type, the other is the number before or before the space. For text-type numbers, copy an empty cell, and then select the number field - Selective Paste - Operation: Plus. Can be converted into a calculated number. For spaces that contain spaces, replace the space directly with the replacement function. Problem: Enter 0 to start the number 0 will be the message, enter more than 15 digits after the 15-bit will become 0 Solution: Enter single quotation marks before entering numbers. Or first set the format for the text and then enter. Question: A1 value is the date 2015-11-13, if the text connection, the result is this Solution: Format the date with the TEXT function = "Today's date is:"