TEXT
Formats a number and converts it to text.
Syntax
=TEXT(Number, FormatString, [Locale])
Arguments
| Name | Description |
|---|---|
| Number | A number value to format and convert. |
| FormatString | A format string. Example format strings are: “$#,##.00” currency with a thousands separator and 2 decimals “MM/DD/YY” Date in format month/day/year, like 03/14/18 “DDDD” Day of week, like Monday “H:MM AM/PM” time, like 1:29 PM “0.0%” percentage, like 28.5% “# ?/?” fraction, like 4 1/3 “0.00E+00” scientific notation, like 1.22E+07 “0000000” add leading zeros, like 0001234 |
| Locale (optional) | An locale code. Currently only “en” and “de” are supported. Defaults to current App locale. |
Return
A formatted string representation of given number value.
Examples
| Formula | Result | Comment |
|---|---|---|
| 3,456.00 (assuming the App language is set to english) |