Skip to main content
Version: Streamsheets 2.5

TEXT

Formats a number and converts it to text.

Syntax

=TEXT(Number, FormatString, [Locale])

Arguments

NameDescription
NumberA number value to format and convert.
FormatStringA 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

FormulaResultComment
=TEXT(3456, "#,##0.00")
3,456.00 (assuming the App language is set to english)