Difference between revisions of "Manuals/calci/SPELLNUMBER"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''SPELLNUMBER (OriginalNumber,MajorUnitPlural,MinorUnitPlural,MajorUnitSingular,MinorUnitSingular,NumberOfDecimals) '''</div><br/> *<math>Original...") |
|||
Line 17: | Line 17: | ||
==See Also== | ==See Also== | ||
*[[Manuals/calci/SPELLINTEGER| SPELLINTEGER]] | *[[Manuals/calci/SPELLINTEGER| SPELLINTEGER]] | ||
− | + | *[[Manuals/calci/SPELLTENS | SPELLTENS]] | |
− | *[[Manuals/calci/ | ||
− | |||
*[[Manuals/calci/SPELLTEENS | SPELLTEENS]] | *[[Manuals/calci/SPELLTEENS | SPELLTEENS]] | ||
− | |||
==References== | ==References== |
Revision as of 14:13, 8 October 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