Convert to a Long Type

Excel VBA: Convert to a Long Data Type

Got any Excel/VBA Questions? Free Excel Help.

The example below shows how CLng can be used in Excel VBA to convert to a Long data type. -2,147,483,648 to 2,147,483,647; fractions are rounded.

Sub ConvertToLong()

Dim vStr, lngNum



vStr = "1000000.589765"

lngNum = CLng(vStr)

MsgBox lngNum



End Sub

See also:

Convert a String or Number to Boolean

Convert a String to a Byte Data Type

Convert to a Currency Data Type

Convert to a Date Data Type

Convert to a Decimal Data Type

Convert to a Double Data Type

Convert to a Integer Data Type

Convert to a Single Data Type

Convert to a String Data Type

Convert Excel Text To Upper Case

Free Training Course: Lesson 1 - Excel Fundamentals

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

Gallery

stars (0 Reviews)

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
OzGrid is in no way associated with Microsoft.

Website designed by Astrava Solutions Ltd.