Overview
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)
Convert Dollar Amount to Words
Step 1: Create a "Selling Price" field
Here we'll just create a regular number field.
Step 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:
PROPER(NUMBERSTOWORDS({Selling Price}))
Step 3: Create a "Cents Amount" field
Use the TRUNC
function which removes the fractional part of the number to parse the cents amount, e.g.: 0.53
{Selling Price} - TRUNC({Selling Price})
Step 4: Create a "Cents to Whole Number" field
Multiply this number by 100, so we get the desired format, e.g. 53 ( to support 53/100)
{Cents Amount} * 100
Step 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.
Step 6: Insert the fields into the document.
Most common Formula used in templates: