SPELLNUMBER
Returns the text after converting a number into words.
number | The number you want to spell out. |
unit_plural | (Optional) The unit to use for whole numbers. |
unit_single | (Optional) The unit to use for 'single' whole numbers. |
decimal_plural | (Optional) The unit to use for decimal numbers. |
decimal_single | (Optional) The unit to use for 'single' decimal numbers. |
display_fraction | (Optional) A logical value indicating if the decimal is displayed as a fraction: False = 0.5 is displayed as 50 (default) True = 0.5 is displayed as 50/100 |
include_and | (Optional) A logical value indicating if the text contains the 'and' word: False = and is not included (default) True = and is included |
include_only | (Optional) A logical value indicating if the text is appended with the word 'only': False = only is not included (default) True = only is included |
include_commas | (Optional) A logical value indicating if the text contains commas: False = commas are not included True = commas are included (default) |
Remarks
* At the moment this function only supports the English language.
* If a number contains more than two decimal places this function will spell out the number as if it was rounded to two decimal places.
* The equivalent VBA function is SPELLNUMBER
link - www.allmath.com/TexttoNumberConverter.php
|
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