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 has been converted to a text string that is formatted according to the server locale settings of the current application instance.
Syntax
TEXT (number)
Arguments
number: Integer or Real
A number that must be converted to a text string.
Return values
String
The resulting text value.
Usage notes
For values of the Real type, the string conversion is limited 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, 2015, as the text string "12/17/2015 07:59:23 AM". TEXT (1/3) returns "0.33".