convert a numeric value into its equivalent

sAYk · Aug 19, 2004

Were can I find a code to insert in my excel worksheet (Module) so I can
convert a numeric value into its equivalent in Spanish words. For example,
change $100.50 into "Cien dolares con cincuenta centavos".

Any help will be most appreciated!

sAYk

Niek Otten · Aug 19, 2004

Here

http://longre.free.fr/downloads/temp/Ntexteng.zip

You can find a download which does almost that, for many languages,
including spanish.
It does not include the "dolares".
If you do a google advanced group search
(http://groups.google.com/advanced_group_search), for "excel" groups, with
the keywords text numbers convert you'll find many others.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

sAYk · Aug 19, 2004

Problem solve, Thanks Niek!

Niek Otten said:
Here

http://longre.free.fr/downloads/temp/Ntexteng.zip

You can find a download which does almost that, for many languages,
including spanish.
It does not include the "dolares".
If you do a google advanced group search
(http://groups.google.com/advanced_group_search), for "excel" groups, with
the keywords text numbers convert you'll find many others.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel