change any given number to words

hi there, i'm newbie in this forum.
hopes i'm posting in the right forum....

here is what i'm trying to make...

when i enter any number (up to 10 digits) in cell A1, cell B1 will change this way....

if the number is 982497 then in B1 will say "nine is first eight is second two is third four is fourth nine is fifth seven is sixth"

first, second, third, is defining the appeared order of the number, BUT I NEED FORMULA THAT NOT JUST DEFINE THIS CONDITION, THAT I CAN CHANGE IT TO ANYTHING.

the number is any numbers between 1-1,000,000,000.

thanks.

PLEASE CHECK THE ATTACHMENT TO UNDERSTAND WHAT I WANT.

Please post more examples, including the shortest and longest values you expect to deal with.

One very basic way using helper columns (can be hidden) and one very long concatenation.(it needs 2007 or above)

Toggle the +/- icon below the formula bar to show/hide the helper columns

See the attached

Originally Posted by Ron Coderre

Please post more examples, including the shortest and longest values you expect to deal with.

emm,, i'm actually kinda confused to explain it in english.. (because i'm indonesian)
hopes this will help...

in cell A1 i can enter any number from 1-1,000,000,000

1 = satu
2 = dua
3 = tiga
4 = empat
5 = lima
6 = enam
7 = tujuh
8 = delapan
9 = sembilan
0 = (blank)

(it's actually the words of numbers in Indonesian, like one, two, three, etc.)

i define the order of number this way.... (right to left)

first: dog
second: cat
third: snake
fourth: owl
fifth: worm
sixth: mouse
seventh: monkey
eigth: fish
ninth: eagle
tenth: pigeon

if i put 7564371 in cell B1 will say "tujuh monkey lima mouse enam worm empat owl tiga snake tujuh cat satu dog"

another example, if i put 341 in cell B1 will say "tiga snake empat cat satu dog"

if i just put 6, then "enam dog"


if you dont mind, please explain how each of formulas work...

thanks so much.

Can you inform us about the purpose of this excercise ?
Maybe there are many simpler alternatives that can perform the same thing.

Please Login or Register  to view this content.

I don't think you know my native language.
But now you are clear.
You underestimated the question.
You shouldn't only look at numbers but also at their position in a concatenation of numbers.

Try this I can't count very well in Indonesian, in fact I can't do it at all, this is the first time I've tried....

Enter a number in Column A (Whole number, or Decimal to two places maximum)

Hope this helps
Semoga ini bisa membantu