SPELLNUMBERREVERSE

Returns the number equivalent for a number written as text.

textThe 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.


microsoft excel docs

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext