1, variable
Deformation data is a special data type, which can be used to save almost all other data types. When we adjust the format of cells, the general type we see is Variant. It can be simply understood as: when you don't know what kind of data a variable represents, you define it as Variant, but this operation should be avoided as much as possible, which will increase the memory pressure of storage and calculation.
2. Line
String is used to store text data, and the contents of the string should be enclosed in double quotation marks. The text in the corresponding cell format form is of string type.
03, digital type
There are four data types used to represent numbers in Excel: integer, long integer, single precision floating point single precision and double precision floating point double precision. Integers and long integers are used to represent integers, and single-precision and double-precision floating-point types are used to represent decimals.
Integers differ from long integers in that they can represent different numerical ranges:
Data range that integer data can represent: -32768 ~ 32767.
The data range that long integer data can represent:-2147483648 ~ 2147483647.
Single-precision floating-point numbers and double-precision floating-point numbers differ in data precision (that is, how many digits after decimal point) except for their numerical ranges.
Single-precision floating-point data range that can be represented.
For negative numbers:-3.402823E38 ~-1.405438+0298e-45.
For positive numbers:1.401298e-45 ~ 3.423e38.
A range of data that can be represented by a double-precision floating-point type
When representing negative numbers:-1.791348 6231e 308 ~-4.44438+0247e-324.
When it represents a positive number: 4.94065645841247e-324 ~1.713486231e308.
Anyway, in a word, they can represent very large data, but it should be noted that the precision of single-precision floating-point type is 6, that is, at most, only 6 digits after the decimal point can be saved; The precision of the double-precision floating-point type is 14, that is, only the data with at most 14 digits after the decimal point can be saved. If the above length is exceeded, the excess will be automatically removed and rounded.
04. Date Type Date
Date data can represent not only date, but also time. The date range that can be expressed is: 1900 65438+ 10/~ nine thousand nine hundred and ninety-nine 65438+February 31; The representative time range is 0:00:00 ~ 23:59:59.
Any date that Excel can recognize can be assigned to a date variable. Because there are many date formats in Excel, there are no examples here. You can try more when you need it.
05, Boolean Boolean type
Boolean data is used to represent logical values: true and false. In which "truth" is true and "false" is false. Boolean data is often used in conditional judgment statements.