CStr Function [Runtime]

From LibreOffice Help
Jump to: navigation, search

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.

Error Codes

5 Invalid procedure call

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