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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for