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 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, 2015, as the text string "12/17/2015 07:59:23 AM". TEXT (1/3) returns "0.33".