A.3. Data Type Conversion Functions
CBool Function
Returns a Boolean data type
CByte Function
Returns a Byte data type
CCur Function
Returns a Currency data type
CDate Function
Returns a Date data type
CDbl Function
Returns a Double data type
CDec Function
Returns a Decimal data subtype
CInt Function
Returns an Integer data type
CLng Function
Returns a Long data type
CSng Function
Returns a Single data type
CStr Function
Returns a String data type
CVar Function
Returns a Variant data type
CVDate Function
Converts expression to Date
CVErr Function
Converts expression to Error
Error Function
Returns an error message as a variant
Error$ Function
Returns an error message as a string
Fix Function
Returns an Integer portion of number
Hex Function
Returns a hexadecimal representation of number as a variant
Hex$ Function
Returns a hexadecimal representation of a number as a string
Int Function
Returns the integer portion of a number
Oct Function
Returns an octal representation of a number as a variant
Oct$ Function
Returns an octal representation of a number as a string
Str Function
Returns a string representation of a value as a variant
Str$ Function
Returns a string representation of a value as a string
Val Function
Returns the Double value of a string representation of a number
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access