What are the data types in excel?

#What are the data types of excel?

Excel’s data types include numerical data, character data, logical data, and date data.

You can enter multiple types of data in Excel cells, such as text, numerical values, dates, times, etc.

1. Character data. In Excel, character data includes Chinese characters, English letters, spaces, etc., and each cell can hold up to 32,000 characters. By default, character data is automatically aligned along the left side of the cell. When the input string exceeds the width of the current cell, if there is no data in the adjacent cell on the right, the string will extend to the right;

If there is data in the cell on the right, the excess data will It will be hidden and can only be displayed after increasing the width of the cell. If the string to be input consists entirely of numbers, such as postal code, phone number, passbook account number, etc., in order to prevent Excel from processing it as numerical data, you can first enter a single quotation mark "'" (English symbol) when inputting. Then enter the specific number.

For example, if you want to enter the phone number "64016633" in the cell, first enter "'64016633" continuously, and then hit the Enter key. "64016633" will appear in the cell, and it will be automatically aligned to the left.

2. Numerical data. In Excel, numeric data includes numbers from 0 to 9 and data containing any symbols such as positive signs, negative signs, currency signs, and percent signs. By default, values ​​are automatically aligned along the right side of the cell. During the input process, there are two special situations to pay attention to.

(1) Negative numbers: You can enter negative numbers by adding a "-" sign before the value or placing the value in brackets. For example, if you want to enter "-66" in a cell, you can enter "( 66)", and then press the Enter key to display "-66" in the cell.

(2) Fraction: To enter data in the form of a fraction in a cell, you should first enter "0" and a space in the edit box, and then enter the fraction, otherwise Excel will treat the fraction as a date. . For example, to enter the fraction "2/3" in the cell, enter "0" and a space in the edit box, then enter "2/3", hit the Enter key, and the fraction "" will appear in the cell. 2/3".

3. Date data and time data. In personnel management, it is often necessary to enter some date-type data. During the entry process, pay attention to the following points:

(1) When entering dates, use the "/" sign between the year, month, and day. Or separated by "-", such as "2002-8-16", "2002/8/16".

(2) When entering time, hours, minutes and seconds should be separated by colons, such as "10:29:36".

(3) To enter date and time in a cell at the same time, the date and time should be separated by a space.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column to learn!

The above is the detailed content of What are the data types in excel?. For more information, please follow other related articles on the PHP Chinese website!