CStr Function

Converts any numeric expression to a string expression.

Syntax:

CStr (Expression)

Return value:

String

Parameters:

Expression: Any valid string or numeric expression that you want to convert.

Expression Types and Conversion Returns

Boolean : String that evaluates to either True or False. Date : String that contains the date and time. Null : Run-time error. Empty : String without any characters. Any : Corresponding number as string.

Zeros at the end of a floating-point number are not included in the returned string.

Example:

Sub ExampleCSTR Dim sVar As String MsgBox CDbl(1234.5678) MsgBox CInt(1234.5678) MsgBox CLng(1234.5678) MsgBox CSng(1234.5678) sVar = CStr(1234.5678) MsgBox sVar End Sub