Syntax:
TEXT(Number, Format)
Description:
This converts a number into a text string in the specified number format.
Use the argument Format to specify the desired format. Enter a corresponding text string here. This must be structured like a text string that you create when creating custom number formats in the dialog box of the ribbon tab Home | group Number
(see Structure of a custom number format).
Additional info:
To change the format of numbers without having to convert them into 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: