Converting numbers and text in a formula field

In addition to using formula functions to convert data types, there are a few alternative options you can implement in your formulas to cause similar conversions.

Number to text string

If you append &"" to a formula working with numbers, then it will convert that value to a string in Airtable. As a reminder, the &operator is equivalent to the CONCATENATE() function. This means you can also add "" to a CONCATENATE() function in order to convert a value to a string.

Examples

{Number field's name} & ""

or

CONCATENATE({Number field's name} , "")

Array to text string

Lookup fields can be appended with &""or "" in a CONCATENATE() function to convert their outputs (arrays) to text for use in text-based functions.

Examples

{Lookup field's name} & ""

or

CONCATENATE({Lookup field's name} , "")

String to a number

• If you append +0 to a function using numeral string from a field in your Airtable base, it will convert the value back to a number and allow number formatting in your formula output.

Example

{Name of the numeral string field that you are referencing} + 0