S
S123
i would like to change in excel program number by letters for example:
1245 = mil doscientos cuarenta y cinco
1245 = mil doscientos cuarenta y cinco
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
pinmaster
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
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
G
Gord Dibben
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
His NBTEXT function supports 11 languages, including Spanish.
http://xcell05.free.fr/morefunc/english/index.htm
Gord Dibben MS Excel MVP
S
Shah Shailesh
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
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