Contenu x
    Converting numbers and text in Airtable formula fields
    • 19 Dec 2023
    • 1 Minute à lire
    • Impression
    • Sombre
      Lumière
    • PDF
    Contenu

    Converting numbers and text in Airtable formula fields

    • Mis à jour le 19 Dec 2023
    • 1 Minute à lire
    • Impression
    • Sombre
      Lumière
    • PDF
    The content is currently unavailable in French. You are viewing the default English version.
    Article Summary

    This article covers how to convert numbers and text in formula fields to streamline your team's and organization's work.

    Introduction

    Plan availability

    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

    Cet article vous a-t-il été utile ?
    What's Next