A Ashok kayithi New Member May 6, 2015 #1 pls help me in to convert numeric to word like ex:1200/- to one thousand two hundred in Excel. any formula for it? Regards Ashok
pls help me in to convert numeric to word like ex:1200/- to one thousand two hundred in Excel. any formula for it? Regards Ashok
bobhc Excel Ninja May 6, 2015 #2 Using the search function brings up http://chandoo.org/forum/search/1307903/?q=convert+numbers+to+text&o=date&c[node]=4 .
Using the search function brings up http://chandoo.org/forum/search/1307903/?q=convert+numbers+to+text&o=date&c[node]=4 .
A Ashok kayithi New Member May 6, 2015 #3 for writing on cheque amount, i want it in word.Rs 1200/- how do we write in word like One Thousand two hundred only .by formula : convert
for writing on cheque amount, i want it in word.Rs 1200/- how do we write in word like One Thousand two hundred only .by formula : convert
Khalid NGO Excel Ninja May 6, 2015 #4 Hi Ashok, See the attached. Don't forget to Enable Macros... copy from: https://sites.google.com/a/yogeshgu...excel-macros/SpellCurrency.xls?attredirects=0 Regards, Attachments SpellCurrency.xls SpellCurrency.xls 46.5 KB · Views: 0
Hi Ashok, See the attached. Don't forget to Enable Macros... copy from: https://sites.google.com/a/yogeshgu...excel-macros/SpellCurrency.xls?attredirects=0 Regards,