Difference between revisions of "Manuals/calci/SPELLNUMBER"

From ZCubes Wiki
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/SPELLNUMBER | SPELLNUMBER]]
 
 
 
 
*[[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

  1. SPELLNUMBER(87) = Eighty Seven Dollars And Zero Cents
  2. SPELLNUMBER(87,3) = Eighty Seven 3 And Zero Cents
  3. SPELLNUMBER(87,3,1) = Eighty Seven 3 And Zero 1

See Also

References