With Formula fields, you can automatically spell numbers to words by following these steps.

If your Dollar amount includes cents, you’ll need some extra formula fields in your document.

In this example, we want to type 14,003.53 into a number field, which automatically inserts the following language into the document: Fourteen Thousand, Three Dollars and 53/100 ( $14,003.53)

Let’s review step by step how to achieve this:

1: Build your Number field:

This is where you will enter the Dollar Amount, e.g.: 14,003.53

Screen Shot 2022-10-06 at 2.50.17 PM

2: Create a Formula field that handles spelling the dollar amount

e.g.: Fourteen Thousand, Three

Screen Shot 2022-10-06 at 2.50.46 PM

3: Use the TRUNC function which removes the fractional part of the number to parse the cents amount

e.g.: 0.53

Screen Shot 2022-10-06 at 2.51.58 PM

4)Multiply this number by 100, so we get the desired format

e.g. 53 ( to support 53/100)

Screen Shot 2022-10-06 at 2.57.35 PM

5: Lastly, set up the final conditional field, so in every case, we have the correct cents number inserted, e.g. if there are no cents amount.

Screen Shot 2022-10-06 at 3.01.30 PM

6: Insert the Fields into the Document!

Screen Shot 2022-10-06 at 3.03.03 PM
Did this answer your question?