All Collections
Advanced Document Automation
Formula Fields
Convert Numbers Automatically Into Words
Convert Numbers Automatically Into Words

Reduce user input and errors but using Formula Fields

E
Written by Eszter Takacs
Updated over a week ago

Advanced.png

1: Create a "Selling Price" field

Here we'll just create a regular number field.

2: Create the "Spell - Selling Price" field

When creating the "Spell- Selling Price" field, instead of selecting "Number" as the field type, select "Formula." Then in the formula input box type:

NUMBERSTOWORDS({Selling Price})

If you type 654,000 into your Number field, your Formula field will automatically produce: six hundred fifty-four thousand

Capitalise Every Word:

  • For additional formatting add the PROPER syntax: PROPER(NUMBERSTOWORDS({Selling Price}))
    ​

  • If you type 654,000 into your Number field, your Formula field will automatically produce: Six Hundred Fifty-four Thousand

All Caps

  • For additional formatting add the UPPER syntax: UPPER(NUMBERSTOWORDS({Selling Price}))
    ​

  • If you type 654,000 into your Number field, your Formula field will automatically produce: SIX HUNDRED FIFTY-FOUR THOUSAND
    ​

Find more Formula use cases below:

Did this answer your question?