Let me know how I can convert a numeric value in text in MS EXCLE
For Example : Convert Rs. 12500 into Text ( Rupees Twelve Thousand Five Hundred Only )
KRIPA SHANKAR BIND (ACCOUNTANTS) (31 Points)
05 January 2010Let me know how I can convert a numeric value in text in MS EXCLE
For Example : Convert Rs. 12500 into Text ( Rupees Twelve Thousand Five Hundred Only )
Exshail
(Software)
(1576 Points)
Replied 05 January 2010
Originally posted by : KRIPA SHANKAR BIND | ||
Let me know how I can convert a numeric value in text in MS EXCLE For Example : Convert Rs. 12500 into Text ( Rupees Twelve Thousand Five Hundred Only ) |
You can download "Indian Rupees" addins from below page
https://shahshaileshs.web.officelive.com/Addins.aspx
With this addin you can also format number as per Indian decimal system (in lakh format)
or
without any vba code download "spellnoformula" from below page
https://shahshaileshs.web.officelive.com/Misc.aspx
Shailesh
Excel Mastery Program