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.

Example:

STRING(123.456, 2)

returns the text string "123.46".

Note that any rounding is carried out according to the same formula as that used by the ROUND function.