Function Spellings Class

SpellNumber

Spells out the DIGITS within any number. Does not spell the number in the same way the SpellCurrency function spells currency amounts.

Signature (Visual Basic / VBA)

Public Function SpellNumber( _
    ByVal vValue As Variant _
    ) As Variant

Code Examples

    SpellNumber("123.45") = "One Two Three Point Four Five"
    %     Percent
    +     Plus
    -     Negative
    .     Point
    0..9  Zero..Nine
    E     Times Ten To The Power Of

Parameters

Parameter Description
vValue The string containing the numeric digits and symbols which are to be spelled. Any characters other than those mentioned in the table above are ignored.

Notes & Version History

Note Function is pre-programmed with the English spelling for the following characters: The function adds a space between each of the characters which have a spelled-out equivalent, and it replaces a single space with three spaces (two spaces plus the one-space character separator).