ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   convert number to text in Spanish Language (https://www.excelbanter.com/excel-worksheet-functions/27846-convert-number-text-spanish-language.html)

Jara

convert number to text in Spanish Language
 
Hi.

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

Thanks for your help.

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/groups?th...D28E%40free.fr

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...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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jara" wrote in message ...
Hi.

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

Thanks for your help.




Ron Rosenfeld

On Wed, 25 May 2005 17:15:31 -0700, "Jara"
wrote:

Hi.

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

Thanks for your help.


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


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com