Str()

Working with Formulas > Functions Used in Formulas > Conversion Functions > Str()

STR() can be used in two ways. The first way to use STR() is to input a number with an optionally specified precision. STR() returns a character string with the number rounded to the specified precision. IF no precision is specified, the function returns a number rounded to zero decimal places.

The second way to use STR() is to input a date as the parameter. STR() returns a character string in a YYYYMMDD format from the specified date expression. If a null date is specified, the function returns a string of eight zeros.

Function Format

STR(number [, precision]) 

STR(date)

Return Value

STR() returns a character string

Examples

STR(10.5) = "11"

STR(1.23456789, 2) = "1.23"

STR(5.555555, 2) = "5.56"

STR(DATE(2002, 12, 25)) = "20021225"

STR(DATE("11/05/2002")) = "20021105"