Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.
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.