STRING(X, N)

 

Description

This function returns the string representing the numeric value of X, formatted to N decimal places, where N is in the range 0 to 15.  Results are rounded.

 

Parameters

 

X

A numeric value.

 

N

A numeric value.

 

Examples

 

STRING(2, 4) = "2.0000"

 

STRING("2", 4) = "0.0000"

 

STRING(SUM(A1:A3), 1) = "1.7"

Where A1 = 0.33, A2 = 0.55, and A3 = 0.77.