Microsoft Office Tutorials and References
In Depth Information
TABlE 6-1: Data Types
dATA T ypE
True or False; 1 or 0; On or Of.
An integer from 0 to 255.
A positive or negative number with up to 15 digits to the
left of the decimal point and up to 4 digits to the right of it.
A floating-point number with the date to the left of the
decimal point and the time to the right of it.
An unsigned integer scaled to the power of 10. The power
of 10 scaling factor specifies the number of digits to the
right of the decimal point, and ranges from 0 to 28.
A floating point number ranging in value from
–1.79769313486231E308 to –4.94065645841247E-324
for negative values and from 4.94065645841247E-324 to
1.79769313486232E308 for positive values.
An integer ranging from –32,768 to 32,767.
An integer ranging from –2,147,483,648 to 2,147,483,647.
A reference to an object, such as a range of cells, a chart,
a pivot table, a workbook, a worksheet, or any one of the
many other objects that are a part of the Excel application.
A floating-point number ranging in value from
–3.402823E38 to –1.401298E-45 for negative values and
from 1.401298E-45 to 3.402823E38 for positive values.
For a variable-length
string, 10 bytes plus
storage for the string
For a fixed-length string,
the storage for the string
There are two kinds of strings: variable-length and
A variable-length string can contain up to approximately
2 billion characters.
A fixed-length string can contain 1 to approximately
Data type for all variables that are not explicitly declared
as some other type, which can contain any kind of data
except fixed-length String data.
For containing numbers,
characters, 22 bytes plus
storage for the characters