TEXT ER function

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".

Additional resources

Text functions