NUMBERFORMAT ER function
The NUMBERFORMAT function returns a String value that presents the specified number in the specified format and in an optionally specified culture. For information about the supported formats, see standard and
custom.
Syntax 1
NUMBERFORMAT (number, format)
Syntax 2
NUMBERFORMAT (number, format, culture)
Arguments
number: Integer or Real
A numeric value that specifies the number that must be formatted.
format : String
A String value that represents the format.
culture: String
A String value that represents the culture to use for formatting.
Return values
String
The resulting text value.
Usage notes
If the culture isn't defined as an argument of the called function, the context that this function is run in determines the culture that is used to format numbers.
Example 1
For the EN-US culture, NUMBERFORMAT (0.45, "p") returns "45.00 %", and NUMBERFORMAT (10.45, "#") returns "10".
Example 2
NUMBERFORMAT (10/3, "F2", "de") returns 3,33, whereas NUMBERFORMAT (10/3, "F2", "en-us") returns 3.33.