In Title: Data types in Microsoft Excel

Data typeLengthDescription
BYTE1 byteNumber from 0 to 255 for storing binary data
INTEGER2Integer from -32 768 to 32 767.
LONG4Integer from -2 147 483 648 to 2 147 483 647
SINGLE4Numeric data type with float precision to 6 decimal digits
DOUBLE8Numeric data type with float precision with double precision in calculatons
CURRENCY8A number with fixed 4 decimal digits
DECIMAL14Numeric data type with fixed precision and scale (precision 28).
STRINGText strings. Flexible lenght or 64 kilobytes
BOOLEAN2Logical value (true or false)
DATE8The date in range from 1.1.100 to 31.12.9999
OBJECT4Reference to an object.
VARIANT16Basic type. May contain special value Null, any numeric value, text, reference to object or variable array.

Post a Comment

Author Name

Contact Form

Name

Email *

Message *

Powered by Blogger.