Skip to main content
📌 More functions: see the Formula function reference.

​
Basics

TEXT is a common AI Table function — converts a number to text in a specified format. Define how numbers display: dates, times, currency, percentages, etc.

​
Syntax

  • value: number or date to convert.
  • format_text: format string.

​
Examples

​
Example 1: Format as Currency

[Field 1] in the first record is 1234.567.
Result: $1,234.57.

​
Example 2: Format Date

[Field 1] in the first record is 2023-03-15.
Result: 03/15/2023. With TEXT, convert numbers or dates into specifically formatted text — fits reports, labels, and any output that needs specific formatting.

​
FAQ

  • Q: How do I drop the time and keep only the date when a function returns yyyy-mm-dd hh:mm? A: Method 1: use TEXT(). New formula field: TEXT([source value], “YYYY-MM-DD”). Method 2: double-click the formula field, switch field type to date, and pick the desired date format.
  • Q: TEXT() returns a number-looking value, but other functions error on it. Why? A: TEXT() output is text. To use it in numeric computation, first wrap with SUM() or ABS() to convert back to a number.