What are the data types in excel?

What are the data types in excel

1.Character data

In Excel, character data includes Chinese characters, English letters, spaces, etc. 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 be hidden and can only be displayed after increasing the width of the cell.

If the string to be entered 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 enter a single quote "" first when inputting (English symbol), and then enter the specific number. For example: If you want to enter a long string of numbers "888888888888" in the cell, first enter "8888888888888" continuously, and then what appears in the cell is "888888888888" instead of 8.89E 20. ,

2. Numerical data

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 "-666" in the cell, you can enter "()" in English. After the brackets, enter "(6666)", and then "-66666" will appear 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 type data and time type data

Date type data and time type 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 the date, use the "/" sign or "-" between the year, month, and day. " separated by numbers, such as "2008-8-16", "2008/8/8".
(2) When entering time, hours, minutes and seconds should be separated by colons, such as "12:00:00".
(3) To enter date and time in a cell at the same time, the date and time should be separated by a space.

Recommended tutorial: "excel tutorial"

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!