Skip to main content

Convert Numbers Automatically Into Words

Reduce user input errors but using Formula Fields.

Updated over 2 weeks ago
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?