Export (0) Print
Expand All

Visual Basic for Applications Reference

Visual Studio 6.0

Str Function

See Also    Example    Specifics

Returns a Variant (String) representation of a number.



The required number argument is a Long containing any valid numeric expression.


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.

© 2014 Microsoft