Hi everyone,
I am trying to do formula/script, which would convert digits in number to text.
For example, i would like to convert number 1234 to one-two-three-four
I created formula:
(VLOOKUP(VALUE(MID(A1;1;1));'1-10'!$A$1:$B$10;2;FALSE))&"-"&(VLOOKUP(VALUE(MID(A1;2;1));'1-10'!$A$1:$B$10;2;FALSE))&"-"&(VLOOKUP(VALUE(MID(A1;3;1));'1-10'!$A$1:$B$10;2;FALSE))&"-"&(VLOOKUP(VALUE(MID(A1;4;1));'1-10'!$A$1:$B$10;2;FALSE)) i have list of text numbers on other sheet for vlookup
and it works, but i want to have maybe some script, which would convert digits to word, no metter how much digits the number has.
I also use IF fuction with LEN, that I convert 7 digits number, 9 digits number or 11 digits number.
Is any way to do this with script, because that formula i wrote is far to long.
Thanks for answers.
Bookmarks