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.
The TEXT function returns the specified number as a String value after it converts the number to a text string that's formatted according to the server locale settings of the current application instance.
Syntax
TEXT (number)
Arguments
number: Integer or Real
The number to convert to a text string.
Return values
String
The resulting text value.
Usage notes
For Real type values, the string conversion includes up to two decimal places.
Example
If the server locale of the Microsoft Dynamics 365 Finance instance is defined as EN-US, TEXT (NOW ()) returns the current Finance session date, December 17, 2025, as the text string "12/17/2025 07:59:23 AM". TEXT (1/3) returns "0.33".