Table of contents
TOC
Collapse the table of content
Expand the table of content

Str Function

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Returns a Variant ( String ) representation of a number. SyntaxStr ( number ) The required numberargument is aLong containing any validnumeric expression. Remarks When numbers are converted to strings, a leading space is always reserved for the sign of number. If number is positive, the returned string contains a leading space and the plus sign is implied. Use the Format function to convert numeric values you want formatted as dates, times, or currency or in other user-defined formats. Unlike Str, the Format function doesn't include a leading space for the sign of number.

Note The Str function recognizes only the period ( . ) as a valid decimal separator. When different decimal separators may be used (for example, in international applications), use CStr to convert a number to a string.

Example

This example uses the Str function to return a string representation of a number. When a number is converted to a string, a leading space is always reserved for its sign.

Dim MyString
MyString = Str(459)    ' Returns " 459".
MyString = Str(-459.65)    ' Returns "-459.65".
MyString = Str(459.001)    ' Returns " 459.001".
© 2017 Microsoft