---
title: "Converting Numbers & Text In Formula Fields | Airtable Support "
slug: "converting-numbers-and-text-in-a-formula-field"
description: "This article covers how to convert numbers and text in formula fields to streamline your team's and organization's work. "
updated: 2025-03-27T04:38:40Z
published: 2025-03-27T04:38:40Z
canonical: "support.airtable.com/converting-numbers-and-text-in-a-formula-field"
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.airtable.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Converting numbers and text in Airtable formula fields

| **Plan Availability** | All plan types |
| --- | --- |
| **Permissions** | - **Owner** / **Creator** - Can add, delete, duplicate, rename, and customize fields - **Editors** - Sort, filter, group, hide, and copy field URL - **Commenters / Read-only** - Copy field URL |
| **Platform(s)** | Web/Browser, Mac app, and Windows app (with some additional limited support on mobile) |

## Converting numbers to text strings in Airtable

If you append `&""` to a formula working with numbers, then it will convert that value to a string in Airtable. Additionally, 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} & ""`
- `CONCATENATE({Number field's name} , "")`

## Converting arrays to text strings in Airtable

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} & ""`
- `CONCATENATE({Lookup field's name} , "")`

## Converting strings to numbers in Airtable

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`