Difference between revisions of "Manuals/calci/SPELLNUMBER"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | <div style="font-size: | + | <div style="font-size:25px">'''SPELLNUMBER (OriginalNumber,MajorUnitPlural,MinorUnitPlural,MajorUnitSingular,MinorUnitSingular,NumberOfDecimals) '''</div><br/> |
*<math>OriginalNumber</math> is any value. | *<math>OriginalNumber</math> is any value. | ||
Revision as of 14:38, 26 November 2018
SPELLNUMBER (OriginalNumber,MajorUnitPlural,MinorUnitPlural,MajorUnitSingular,MinorUnitSingular,NumberOfDecimals)
- is any value.
Description
- This function shows the spelling or number name of the given number.
- Argument number can be any whole number or decimal number.
- The whole number will consider as dollar and the decimals will consider as cents.
- For non-numeric argument such as character,string or special characters,will display as non numeric dollar and non numeric cents.
Examples
- SPELLNUMBER(87) = Eighty Seven Dollars And Zero Cents
- SPELLNUMBER(87,3) = Eighty Seven 3 And Zero Cents
- SPELLNUMBER(87,3,1) = Eighty Seven 3 And Zero 1
See Also
References