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".