spellcurrency

Type

Spell Function

Purpose

The spellcurrency function spells the monetary equivalent of a numeric value.

Syntax

spellcurrency( NUMERIC VALUE)

Returns

A text value.

Examples

spellcurrency( 36.25)

Returns: Thirty Six Dollars and 25 Cents

spellcurrency( 210.00)

Returns: Two Hundred Ten Dollars and 00 Cents

spellcurrency( TOTAL DUE)

Returns:The spelled-out currency amount in the TOTAL DUE field for every record processed. If a record contains the value 905.75, the function returns Nine Hundred and Five Dollars and 75 Cents.

Note: the actual currency used is determined by which regional version of DataEase you have purchased. UK users, for example, should see the words ?pounds? and ?pence? instead of ?dollars? and ?cents?.