SPELLNUMBERREVERSE
Returns the number equivalent for a number written as text.
text | The numeric value as text. |
Remarks
* At the moment this function only supports the English language.
* The "word" can only contain numbers, no currencies.
* This function is not case sensitive.
* The equivalent VBA function is SPELLNUMBERREVERSE
| A | 1 | =JS.SPELLNUMBERREVERSE("Six") | 2 | =JS.SPELLNUMBERREVERSE("Six pound") | 3 | =JS.SPELLNUMBERREVERSE("Six pounds") | 4 | =JS.SPELLNUMBERREVERSE("One Hundred") | 5 | =JS.SPELLNUMBERREVERSE("one HUNDRED") | 6 | =JS.SPELLNUMBERREVERSE("Two Thousand and Seventeen") | 7 | =JS.SPELLNUMBERREVERSE("Two Thousand Seventeen") | 8 | =JS.SPELLNUMBERREVERSE("One million Three HUNDRED and Forty Five") | 9 | =JS.SPELLNUMBERREVERSE("Six hundred") | 10 | =JS.SPELLNUMBERREVERSE("Six thousand") | 11 | =JS.SPELLNUMBERREVERSE("Six million") | 12 | =JS.SPELLNUMBERREVERSE("Six billion") |
|
1 - What is the word "six" converted to a numerical value.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext