Skip to main content

Convert Numbers Automatically Into Words

Reduce user input errors but using Formula Fields.

Advanced.png

Overview

Follow the steps below to convert numbers automatically into words using Advanced Document Automation in 8am™ MyCase.

Convert Numbers Automatically Into 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:

NUMBERSTOWORDS({Selling Price})

If you type 654,000 into your Number field, your Formula field will automatically produce: six hundred fifty-four thousand

Capitalize Every Word:

  • For additional formatting add the PROPER syntax: PROPER(NUMBERSTOWORDS({Selling Price}))
    ​

  • If you type 654,000 into your Number field, your Formula field will automatically produce: Six Hundred Fifty-four Thousand

All Caps

  • For additional formatting add the UPPER syntax: UPPER(NUMBERSTOWORDS({Selling Price}))
    ​

  • If you type 654,000 into your Number field, your Formula field will automatically produce: SIX HUNDRED FIFTY-FOUR THOUSAND
    ​

Find more Formula use cases below:

Related Articles
Calculate Age Automatically based on Date of Birth
Convert Dollar Amount to Words Which Includes Cents: e.g. 14,003.53
Add or Subtract Dates Automatically
Did this answer your question?