Kuovonne's Guide to Airtable

Explore

Kuovonne's Guide to Airtable

Data Type Conversion in Formulas

Numbers to Text
Numbers to Text

⁠

⁠ Tip Jar ⁠ Thank Kuovonne for creating this content! ⁠ ⁠ ⁠

⁠

You can convert a number to text by concatenating it with something else using & or CONCATENATE().

The quickest way to ensure that a field value is text is to concatenate it with an empty text string:

{field} & ""

Rounding Numbers

When converting number fields to text, the resulting text is the number as it is stored, not as is displayed. For example, a formula field might display a number with two decimal places, but actually have more decimal places when converted to text.

⁠

Here is the formula for that last column.

"The quotient is " & ROUND({Quotient}, 2)

Consider using ROUND() in the original formula instead, depending on the effect you want on any downstream calculations.

Percents

Because percents are stored as decimals, you must multiply times 100 if you want the text to display as a percent.

"Save " & ({Percent} * 100) & "%!"

⁠

Other Issues

When converting a number to text you may have other issues, such as

missing trailing zeros when you always want a specific number of decimal places

missing grouping and decimal symbols (commas and periods)

These formulas can be a little more complex. I recommend using my extension

Ready Made Formulas

⁠

with a

premium license

⁠

for a formula that addresses these formatting issues.

⁠

⁠ ⁠ Thank Kuovonne for creating this content! ⁠ Give Kuovonne a sandwich ⁠ Signup for Coda w/ referral link ⁠ ⁠ ⁠Buy from my Gumroad Store ⁠ ⁠ ⁠ ⁠ ⁠

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.

Numbers to TextNumbers to Text

Rounding Numbers

Consider using ROUND() in the original formula instead, depending on the effect you want on any downstream calculations.

Percents

Other Issues

Numbers to Text
Numbers to Text