convert number to text in Spanish Language

J

Jara

Hi.

I would like to know if somebody knows a function to convert number to text
in Spanish Language.

Thanks for your help.
 
D

David McRitchie

Hi Jara,
Check Laurent Longre's site (in French) he posted for testers and
one of the languages was for Spanish.
http://groups.google.co.uk/[email protected]

The file to download is
http://longre.free.fr/downloads/temp/Ntexteng.zip

I have some information on English in
http://www.mvps.org/dmcritchie/excel/strings.htm#wordstonumbers

BTW, tell us whether Laurent's code works for you or not. I don't think anyone
has posted that information, but since he asked for testers 4 years ago, I imagine
it should work.
 
R

Ron Rosenfeld

Hi.

I would like to know if somebody knows a function to convert number to text
in Spanish Language.

Thanks for your help.
Click to expand...

Download Laurent Longre's free morefunc.xll add-in from http://xcell05.free.fr/
and use his NBTEXT function. NBTEXT is capable of many languages -- not sure
about the documentation languages, though.

Example:

1357 Mil trescientos cincuenta y siete


--ron
 
Top