Syntax:
TEXT(Number, Format)
Description:
Converts a number to a text string in the specified number format.
Format is a text string specifying the desired format. Enter a corresponding text string here. It has to be built like a format string for user-defined number formats that you specify in the dialog box of the ribbon tab Home | group Number
(see Structure of a custom number format).
Annotation:
To change the format of numbers without having to convert them to a text string, choose the commands of the ribbon tab Home | group Number and select the desired number format.
Example:
TEXT("9/25/2018", "MM/DD/YY") returns 09/25/18 (as a text string)
TEXT(2.715, "0.00 ""USD""") returns 2.72 USD (as a text string)
See also: