STRING

Converts a number into a text string with a number of decimal places.

Syntax:

STRING( number, digits:Number )

Converts the given number into a text string with digits decimal places.

Rounding is carried out according to the same formula as that used by the ROUND() function.

Example:

STRING(123.456, 2)

returns the text string "123.46".