"Translating" numbers into words

Hi,

I´m trying to automate the payment process for employee totals and bank transfers for checks and and nominas.

What I would basically like to do is this:

Imagine in cell A1 is the number 11.233,23 I would basically like excel to translate the number into. "Eleven thousand two hundred and thirty four euros and 23 cents"

Any ideas?

Hi,

Thanks for link, its really helpfull.

I´m trying to adapt the code to translate into spanish and venezuelan Bolivares and so far I have come to only 1 (ONE) problem that I hope you could help me with.


With the thousand it will put "Un" before "Mil" but in spanish thats wrong.

1000 - is just "mil" not "Un Mil"
1001 is "mil uno" not "Un Mil Uno"

The way the code is, it will put the 1 digit number before the thousand.

with 2000, 3000, etc, I have no problem, 2000 is "dos mil"

Any help is more than welcome!

Bellow is the modified code i managed to adapt:

Please Login or Register  to view this content.

Finnally finished the code and got around the problem of:

1000 - is just "mil" not "Un Mil"
1001 is "mil uno" not "Un Mil Uno".

Please Login or Register  to view this content.

This function,s problems can be solved with the following formula referencing the cell where the result of the function is:

Please Login or Register  to view this content.