G Guest Nov 16, 2007 #1 i would like to change in excel program number by letters for example: 1245 = mil doscientos cuarenta y cinco
i would like to change in excel program number by letters for example: 1245 = mil doscientos cuarenta y cinco
G Guest Nov 16, 2007 #2 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
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
G Gord Dibben Nov 17, 2007 #3 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
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
S Shah Shailesh Nov 18, 2007 #4 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
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
