Microsoft Office Tutorials and References
In Depth Information
Data Types
TABlE 6-1: Data Types
dATA T ypE
dEscripTion
MEMory
Boolean
True or False; 1 or 0; On or Of.
2 bytes
Byte
An integer from 0 to 255.
1 byte
Currency
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.
8 bytes
Date
A floating-point number with the date to the left of the
decimal point and the time to the right of it.
8 bytes
Decimal
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.
12 bytes
Double
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.
8 bytes
Integer
An integer ranging from –32,768 to 32,767.
2 bytes
Long
An integer ranging from –2,147,483,648 to 2,147,483,647.
4 bytes
Object
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.
4 bytes
Single
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.
4 bytes
For a variable-length
string, 10 bytes plus
storage for the string
For a fixed-length string,
the storage for the string
String
There are two kinds of strings: variable-length and
ixedlength.
A variable-length string can contain up to approximately
2 billion characters.
A fixed-length string can contain 1 to approximately
64,000 characters.
Variant
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,
16 bytes
For containing
characters, 22 bytes plus
storage for the characters
Search JabSto ::




Custom Search