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.

Additional resources

Text functions