1, open the Excel spreadsheet program, enter the main interface of the Excel program, and enter the first number.
2. Then, select the cross in the lower right corner of the cell and drag it down.
3, you can see that Excel has filled in the same content.
4. Right-click the area, and then click Fill Sequence on the right-click menu.
5. Finally, you can see that the numbers in Excel are set by adding one in turn, and the problem is solved.
2. How to solve the problem that the input number in excel becomes E+
Original publisher: Teacher Zhi
How to solve the problem that the input number becomes E+ in excel? Recently, when my friend used excel, he entered a long string of numbers (such as ID number). After the input was completed, he found that this string of numbers automatically became xxxxE+xx, which was puzzling. He called me for help. In fact, I knew it should be the cell format, and asked him to format the cell as text. Unfortunately, my friend's computer level is relatively low, and he didn't understand it after talking on the phone for a long time, so this reason. There are two feasible ways to solve the problem shown in the above figure: first, before we enter the number, we enter the single quotation mark (the single quotation mark is the two digits behind the L key, that is, the key with double quotation marks), and then enter the number, so that the number we enter is in text format and will not automatically deform. (This method is recommended) Method 2. Right-click the number of cells, select Cell Format, set the value category to text, and re-enter the number. Note: ① Please make sure that the number you entered does not pass the calculation, such as the ID number entered at the beginning of this article. ② When inputting single quotation marks, please switch the input method to English input state. Conclusion: I always thought that I only knew how to modify the cell format, but I didn't expect to search online and found that I could put a single quotation mark in front of the number. In fact, adding single quotation marks in front of numbers is a relatively fast way to input numbers into text format, which is a very convenient trick. I hope everyone collects and studies. How to enter numbers starting with 0 in Excel We often enter numbers like "04 170" in Excel cells in our daily work. For example, when processing grades, we need to input the student number (assuming that the student number is 0400 1 to 04 100), but when we directly input it, we will find that the previous "0" disappears, and the solution is simple. 1.
3. How to solve the problem that the input number in excel becomes E+
Open a library member with a minimum of 0.27 yuan, and view the full content > Original Publisher: How does Teacher Zhi solve the problem that the numbers entered in excel become E+? My friend recently entered a long string of numbers (such as ID number) when using excel. After the input was completed, he found that this string of numbers automatically became xxxxE+xx, which was puzzling. He called me for help. In fact, I knew it should be the cell format, and asked him to format the cell as text. Unfortunately, my friend's computer level is relatively low, and he didn't understand the phone for a long time.
There are two feasible ways to solve the problem shown in the above figure: first, before we enter the number, we enter the single quotation mark (the single quotation mark is the two digits behind the L key, that is, the key with double quotation marks), and then enter the number, so that the number we enter is in text format and will not automatically deform. (This method is recommended) Method 2. Right-click the number of cells, select Cell Format, set the value category to text, and re-enter the number.
Note: ① Please make sure that the number you entered does not pass the calculation, such as the ID number entered at the beginning of this article. ② When inputting single quotation marks, please switch the input method to English input state.
Conclusion: I always thought that I only knew how to modify the cell format, but I didn't expect to search online and found that I could put a single quotation mark in front of the number. In fact, adding single quotation marks in front of numbers is a relatively fast way to input numbers into text format, which is a very convenient trick. I hope everyone collects and studies. How to enter numbers starting with 0 in Excel We often enter numbers like "04 170" in Excel cells in our daily work. For example, when processing grades, we need to input the student number (assuming that the student number is 0400 1 to 04 100), but when we directly input it, we will find that the previous "0" disappears, and the solution is simple.
1.。
4. How to add the numbers in the computer table?
Excel supports four operations in mathematics, just write the corresponding formula directly in the target cell. For example, to find the difference between A 1 and B 1, you can enter =A 1-B 1 in cell C 1.
note:
Any formula in Excel (including four mathematical operations) needs to start with an equal sign.
Asterisks in Excel are indicated by backslashes/. X in multiplication is indicated by an asterisk *.
Excel's four sides and four arithmetic operations conform to the four arithmetic rules in mathematics, that is, multiply first and then divide, and then add and subtract.
Tip: If the cell data involved in calculation is stored in text form, it will not participate in any operation and report an error. In this case, you can enter two minus signs after the equal sign, and then enter the formula. Double minus sign can be understood as changing the number stored in text form into digital form and participating in calculation.
In addition, you can use the SUM function to sum the total.
SUM Usage: Returns the sum of all numbers in a cell range.
Syntax: SUM(number 1, number2),.
Parameters: Number 1, number2, numerical values (including logical values and text expressions), ranges or references to be summed.
Note: Numbers, logical values and text expressions of numbers in the parameter table can all participate in the calculation, where logical values are converted into 1 and texts are converted into numbers. If the parameter is an array or a reference, only the numbers in it are calculated, and blank cells, logical values, text or error values in the array or reference are ignored.
Example: If A 1= 1, A2=2 and A3=3, the formula "=SUM(A 1:A3)" gives 6; =SUM("3 ",2, TRUE) returns 6, because" 3 "is converted to the number 3 and the logical value TRUE is converted to the number 1.
5. How to modify the Excel digital display E+
This is a scientific notation expression, such as 1.23457E+ 17, which means 1.23457 multiplied by 17 to the power of 10.
One: If a scientific counting expression is generated only because the column width of a cell is too small, you can change the display style by enlarging the column or setting the column width. For example, if the number written is more than 5 digits, the number is 1 1 and below, and the cell is too small, it will be displayed as a scientific counting expression.
Two: Under the normal format, EXCEL will display numbers exceeding 1 1 digits in scientific notation, and you can change the cell format to special-postal code -OK, but it is only valid for numbers within 12 digits. For numbers exceeding 12 digits, set the cell format as a number format and set the decimal places.
Third; However, even if the numerical format is set, if the number string written exceeds 15 bits, because the numerical precision of EXCEL is 15 bits, the part of the number string exceeding 15 bits will be filled with 0. Therefore, before entering a long numeric string, you should set the cell format to text format.
6. How to automatically add 30 to all numbers in 6.EXCEL?
Tools/raw materials
Excel20 16 edition, win 10 computer.
1, open the computer to find and double-click to open the excel20 16 form software;
2. After double-clicking to open the form software, edit any digital content for demonstration;
3. After editing the digital content, select the cell in column B and enter = a1+30 in the editing field;
4. After entering the formula, press "ctrl+ ENTER" to fill in the formula to complete the addition of numbers.