Difference between revisions of "Manuals/calci/SPELLNUMBER"
Jump to navigation
Jump to search
(One intermediate revision by the same user not shown) | |||
Line 14: | Line 14: | ||
# SPELLNUMBER(87,3) = Eighty Seven 3 And Zero Cents | # SPELLNUMBER(87,3) = Eighty Seven 3 And Zero Cents | ||
# SPELLNUMBER(87,3,1) = Eighty Seven 3 And Zero 1 | # SPELLNUMBER(87,3,1) = Eighty Seven 3 And Zero 1 | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|v=e0dJWfQHF8Y|280|center|Numbers}} | ||
==See Also== | ==See Also== |
Latest revision as of 14: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