Skip to content
missing trailing zeros when you always want a specific number of decimal placesmissing grouping and decimal symbols (commas and periods)
Kuovonne's Guide to Airtable
- Pages
Share
Explore
Numbers to Text
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
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!
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.