Convert Numbers (5000) Automatically to Currency ( 5,000.00) and Spell the Amount ( Five Thousand) in your Templates

Formula fields will bring your document automation game to the next level.

Besides handling mathematical operations and dynamic dates, you can also convert numbers into currency or/and words.

Let’s say you need to insert a Loan amount into the document. If you use Formulas, you only have to type the numbers; the currency and the spelled version will automatically populate.

1)Currency:
Refer to the already existing loan amount field in the Formula text box. In the Format text box, select the currency format.

2)Numbers to Words
Use the “NUMBERSTOWORDS” formula for spelling the number. If you add the “PROPER” formula before, then it will capitalize every word in the loan amount.

1 Like