CLng Function

CLng Function

---

Syntax

     Dim result As Long = CLng(expression) 

expression (required; Numeric or String)

Any expression in the valid range of the Long data type

Description

The CLng function converts expression to the Long data type; any fractional portion of expression is rounded.

Usage at a Glance

• An expression that evaluates outside the valid range of the target data type results in a runtime error. Nonnumeric expressions also generate an error.

• In most cases, the numeric conversion functions are a better choice than the Val function when converting a string, as the conversion functions take into account the system's regional settings. However, Val converts empty strings to zero without error.

• Use IsNumeric to test whether expression evaluates to a number.

• This function does not support named arguments.

• CLng differs from the Fix and Int functions, which truncate, rather than round, the fractional part of a number. Also, Fix and Int always return the same data type as what was passed in.

Example

     Dim targetNumber As Long     If IsNumeric(stringNumber) Then        targetNumber = CLng(stringNumber)     End If 

Version Differences

The CLng function under .NET returns a 64-bit integer; the VB 6 CLng function returned a 32-bit integer.

See Also

CInt Function, CShort Function, CULng Function