All Collections
Working With Woodpecker Fields
More about Formula Field
How to Spell Dollar Amount Which Includes Cents: e.g. 14,003.53
How to Spell Dollar Amount Which Includes Cents: e.g. 14,003.53

How to use Formula fields to maximize document automation

Eszter Takacs avatar
Written by Eszter Takacs
Updated over a week ago

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?