How to Spell Dollar Amount Which Includes Cents: e.g. 14,003.53

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)

An example template can be downloaded here, and you can copy& paste the fields into your template
Formulas.docx (20.7 KB)

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

2: Create a Formula field that handles spelling the dollar amount., e.g.: Fourteen Thousand, Three

3: Use the TRUNC function which removes the fractional part of the number to parse the cents amount, e.g.: 0.53

4)Multiply this number by 100, so we get the desired format, e.g. 53 ( to support 53/100)

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.

  1. Insert the Fields into the Document!