There are plenty of online resources to convert Numeric currencies to Text- from $200 to Dollar Two Hundred. But this is applicable only ###,###,### (comma at every third number)format. This is not suitable for India numbering system, because we follow ##,##,###(....22,22,222) format. So I have create a excel function to over come this. You can use this function to to convert number up to 10,00,00,000(ten crores). How to do it Open Excel Press Alt + F11 From Menu Bar Insert Module Copy paste the This Module there. Exit from VBA window by pressing Alt + F11 again In excel sheet, Insert Function, Under user defined find ConvertCurrencyToEnglish select it and provide the number as a parameter thats all you are done ---------------------------------------------------------------------- Code (alternatively you can download the module from here ) ---------------------------------------------------------------------- ' ...
Comments
Post a Comment