Input EXCEL7 type special format data

Source: Internet
Author: User
Tags current time numeric

In cells in an Excel worksheet, you can use two of the most basic data formats: constants and formulas. Constant refers to the literal, data such as numbers, dates, and times can also include logical and error values, each with its specific format and input method, and to give users a clear understanding of the input data, it is necessary to introduce the methods and techniques for entering various types of data in Excel.

One, input text

The text in an Excel cell includes any combination of Chinese and Western text or letters, as well as numbers, spaces, and non-numeric characters, which can hold a maximum of 32,000 characters in each cell. Although there is no essential difference between entering text in Excel and in other applications, there are some differences, such as our in Word, PowerPoint tables, when you enter text in a cell, press ENTER to indicate the end of a paragraph, The cursor is automatically moved to the beginning of the next paragraph in this cell. When you enter text in a cell in Excel, when you click Enter to end the input of the current cell, the cursor automatically moves to the next cell in the current cell, and if you want to branch in the cell, You must enter a hard return in the cell, that is, press ENTER while holding down the ALT key.

Second, input points

In almost all of the documents, fractional format is usually a slash to the numerator and denominator, the format is "numerator/denominator", in Excel, the date of the input method is also used to distinguish between month and day, such as in the cell input "1/2", press ENTER to display "January 2", To avoid confusing the input score with the date, when we enter a score in a cell, we need to enter "0" (0) before the score to differentiate it, and a space between "0" and the molecule, for example, when we enter 1/2, we should enter "0 1/2". If you enter "8 1/2" in the Cell, "8 1/2" is displayed in the cell, and "8.5" is displayed in the formula bar.

Third, enter negative numbers

When you enter a negative number in a cell, you can enter "-" to identify it before negative numbers, or you can place numbers in () brackets to identify them, such as entering "(88)" In a cell, and clicking the Enter key automatically appears as "-88".

Four, enter decimal

When you enter decimals, users can use the decimal point as usual, and you can use commas to separate thousands and millions, and when you enter numbers with commas, they are not displayed in the formula bar, but only in cells. When you need to enter a large number with fixed decimal digits or digits with fixed digits ending with a "0" string, you can use the following methods: Select the tools, Options command, open the Options dialog box, click the Edit tab, select the Automatically set decimal point check box, and in the number of digits In the spinner, enter or select the number of digits to display to the right of the decimal point if you want to automatically add 0 after you enter a larger number. You can specify a negative value as the number of 0 you want to add, such as adding 3 zeros to the cell after you enter "88", and then "88 000", and then entering "-3" in the digits spinner, Instead, if you want to automatically add 3 decimal places to "0.088" after you enter "88", enter "3" in the bits spinner. Also, after you have entered a number with a decimal or ending 0 string, you should clear the Select the Automatically set decimal point check box so that you do not affect the input behind it, or you can bring a decimal point when you enter data if you want to temporarily cancel the option set in automatic decimal.

Five, enter the currency value

Excel supports almost all currency values, such as RMB (¥), Sterling (£), and so on. After the introduction of the euro, Excel2000 fully supports the display, input and printing of the euro currency symbol. Users can easily enter various currency values in a cell, Excel automatically formats the currency, displays in the cell, and if you want to enter a renminbi symbol, you can hold down the ALT key and then press "0165" on the numeric keypad. (http://www.3lian.com/)

Six, enter the date

Excel treats dates and times as numbers, and it recognizes most of the date and time formats that are entered in the normal notation. Users can enter a date in several formats, using a slash "/" or "-" to separate the year, month, and day portions of the date. For example, to enter "December 1, 2001", you can enter "2001/12/1" or "2001-12-1" in a variety of units. If you want to insert the current date in a cell, press CTRL + on the keyboard and combine keys.

Seven, enter the time

When you enter time in Excel, users can enter the 24-hour system, or 12-hour input, the two input methods are different, such as to enter 2:30 P.M. 38 seconds, with 24-hour input format is: 2:30:38, and 12-hour input time format is: 2 : 30:38 p, note that there is a space between the letter "P" and the time. If you want to insert the current time in a cell, press the ctrl+shift+ key.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.