Gallery
Kuovonne's Guide to Airtable
Share
Explore
Kuovonne's Guide to Airtable
Data Type Conversion in Formulas

Numbers to Text

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.
image.png
Here is the formula for that last column.
"The quotient is " & ROUND({Quotient}, 2)
ok

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) & "%!"
image.png

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 with a for a formula that addresses these formatting issues.
Thank Kuovonne for creating this content!

Share
 
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.