SPELLNUMBER
Returns the word equivalent for a numerical number.
my_number  The number you want to spell out. 
main_unit_plural  (Optional) The unit to use for whole numbers. 
main_unit_single  (Optional) The unit to use for 'single' whole numbers. 
decimal_unit_plural  (Optional) The unit to use for decimal numbers. 
decimal_unit_single  (Optional) The unit to use for 'single' decimal numbers. 
fractional_decimal  (Optional) True (default) 
include_and  (Optional) False (default) 
include_only  (Optional) False (default) 
include_commas  (Optional) True (default) 
Remarks
* At the moment this function only supports the English language.
* If a number contains more than two decimals this function will spell out the number as if it was rounded to two decimals.
* The equivalent VBA function is SPELLNUMBER

1  What is the number '6' converted to words.
What is the number '5' converted to words.
2  What is the number '6' converted to words with the pound unit attached.
3  What is the number '1' converted to words.
4  What is the number '200' converted to words.
5  What is the number '2017' converted to words.
6  What is the number '2017' converted to words with the pound until attached.
7  What is the number '2004' converted to words.
8  What is the number '1000345' converted to words.
What is '0.124' converted to words.
9  What is the number '0.9' converted to words.
10  What is the number '20.123' converted to words.
11  What is the number '1000000' converted to words.
12  What is the number '50000000' converted to words.
13  What is the number '50003600' converted to words.
14  What is the number '1001001100' converted to words.
15  What is the number '1001001110' converted to words.
16  What is the number '9999999999999' converted to words.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext