- 19 Dec 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
Converting numbers and text in Airtable formula fields
- Updated on 19 Dec 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
This article covers how to convert numbers and text in formula fields to streamline your team's and organization's work.
Introduction
All plan types | |
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading |
Converting numbers to text strings in Airtable
Converting numbers to text strings
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.
{Number field's name} & ""
CONCATENATE({Number field's name} , "")
Converting arrays to text strings in Airtable
Converting arrays to text strings
Lookup fields can be appended with &""
or ""
in a CONCATENATE()
function to convert their outputs (arrays) to text for use in text-based functions.
{Lookup field's name} & ""
CONCATENATE({Lookup field's name} , "")
Converting strings to numbers in Airtable
Converting strings to numbers
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.
{Name of the numeral string field that you are referencing} + 0