Difference between revisions of "Manuals/calci/SPELLNUMBER"
Jump to navigation
Jump to search
Line 17: | Line 17: | ||
==Related Videos== | ==Related Videos== | ||
− | {{#ev:youtube|v= | + | {{#ev:youtube|v=e0dJWfQHF8Y|280|center|Numbers}} |
==See Also== | ==See Also== |
Latest revision as of 13:04, 4 April 2019
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
Related Videos
See Also
References