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.
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext