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). |