i would like to change in excel program number by letters for example:
1245 = mil doscientos cuarenta y cinco

Hi,

Have a look here http://www.ozgrid.com/VBA/ValueToWords.htm
for more links try a quick search on google for "convert numbers to text"

Note that you will have to adapt it if you want the conversion in a
different language.

Good luck!
Jean-Guy

"S123" wrote:

i would like to change in excel program number by letters for example:
1245 = mil doscientos cuarenta y cinco

Download Laurent Longre's MOREFUNC add-in.

His NBTEXT function supports 11 languages, including Spanish.

http://xcell05.free.fr/morefunc/english/index.htm


Gord Dibben MS Excel MVP

On Fri, 16 Nov 2007 15:09:00 -0800, S123 wrote:

i would like to change in excel program number by letters for example:
1245 = mil doscientos cuarenta y cinco

Besides you can download "spellnoformula" (scroll to 4) from below webpage,
which has formula to convert numbers to words. No VBA codes required.

http://in.geocities.com/shahshaileshs/misc.htm


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://in.geocities.com/shahshaileshs/menuaddins



"S123" wrote in message
...
i would like to change in excel program number by letters for example:
1245 = mil doscientos cuarenta y cinco