Many people start to use Excel to work, often input a lot of data in Excel, in order to convey a clear understanding of the input data, it is necessary to analyze the methods and tips for inputting various types of data in Excel. In the cells of the Excel office table, the two most basic data patterns can be used: constants and formulas. Constants are data such as words, numbers, dates, and moments. They can also contain logical values and fault values. Each data has its own specific pattern and input method. I. Entering Text The text in an Excel cell contains any combination of Chinese and Western text or letters and numbers, spaces, and non-numeric characters. Each cell can hold up to 32,000 characters. Although there is no essential difference between entering text in Excel and other applications, there are still some differences. For example, in Word and PowerPoint tables, when you enter text in a cell, press Enter to indicate a stage. After the completion, the cursor will move to the initial stage of the next stage in the cell. When inputting text in the cell of Excel, press the Enter key to indicate the input of the cell at the time, and the cursor will move to the cell at that time. The next cell, when this situation is present, if you want to branch in the cell, you must enter a hard return in the cell, that is, hold down the Alt key and press the Enter key. Second, the input score is almost in all documents, the score pattern usually uses a slash to demarcate the numerator and denominator, the pattern is "Molecular /denominator", the date input method in Excel is also a slash to distinguish the year and month For the day, for example, enter “1/2” in the cell, press Enter to display “January 2”, in order to prevent the input score from being mixed with the date, when we enter the score in the cell, To enter the score before the score, “0” (zero) to show the difference, and there should be a space between the "0” and the numerator, for example, when we enter 1/2, you should enter “0 1/2”. If you enter “8 1/2” in the cell, then “8 1/2” appears in the cell, and “8.5” appears in the modification bar. 3. Entering a negative number When you enter a negative number in a cell, you can enter "ld" before the negative number, or you can mark the number in () brackets. For example, enter "ldquo;;88" in the cell. ;, press the Enter key, it will automatically appear as "-88". 4. Entering decimals When inputting decimals, users can always use the same decimal point. They can also use commas to separate thousands, millions, etc. When entering a number with a comma, the modified bar does not appear, but only in the Appears in the cell. When you need to enter a number with a fixed number of decimal places or a number with a fixed number of digits ending with a string of '0”; you can choose the following method: Pick the "something>;“options" , open the "Options" dialog box, click the "Edit" label, select the "Actively set decimal point" check box, and enter or select in the "Number of digits" spin box to appear in the decimal point The number of digits on the right side, if you want to add zero after inputting a relatively large number, you can specify a negative value as the number of zeros to be increased. For example, if you enter "<quo;88” in the cell, you will add 3 zeros. In the "digits" spinner, enter “-3”, conversely, if you want to add 3 decimals after entering “88”, it becomes “0.088” , you would enter “3” in the "digits" spinner. In addition, after entering the number with decimal digits or ending zero string, the selection of the "actively set decimal point" checkbox should be removed to avoid affecting the input afterwards; if it is only temporarily suspended in "ldquo; Actively set the option set in the decimal point, you can bring a decimal point when entering data. 5. Entering the money and silver value Excel can support all the money and silver value, such as RMB (¥), GBP (£) and so on. In the future, the Euro 2000 will fully support the display, input and printing of the euro money and silver symbols. Users can easily enter various money and silver values in the cell. Excel will actively apply the money and silver pattern and display it in the cell. If you want to input the RMB symbol, you can hold down the Alt key and then the numeric keypad. Press “0165” 6. Entering Dates Excel treats dates and moments as digital, and it recognizes the date and time patterns that are mostly entered using the usual means. Users can enter a date in a variety of formats, and can use the slash “/” perhaps “-” to separate the year, month, and day of the date. For example, to enter "December 1, 2001", can input in the unit "2001/12/1", perhaps "2001-12-1". If you want to pierce the date in the cell, you can press Ctrl+; on the keyboard. 7. When inputting time Enter the time in Excel, the user can input in 24-hour format, and can also input in 12-hour format. The indications of these two inputs are different, for example, inputting 2:30:38 in the afternoon. The 24-hour input format is 2:30:38, and the 12-hour input time pattern is: 2:30:38 p, paying attention to the letter <p” and there is a space between the moments. If you want to pierce the time in the cell, press Ctrl+Shift+; The system tutorial content is for reference only, if you need to solve specific problems, it is recommended that you consult the professionals in the relevant fields.