Hi their, this is the amount 236450 , I want to convert it like that "TWO LAC THIRTY SIX THOUSAND FOUR HUNDRED FIFTY ONLY"
this is only example i want every amount which i entered convert in to word
so please give me formula or vba code
Hi their, this is the amount 236450 , I want to convert it like that "TWO LAC THIRTY SIX THOUSAND FOUR HUNDRED FIFTY ONLY"
this is only example i want every amount which i entered convert in to word
so please give me formula or vba code
Here is an example of what you are trying to achive more or less:
https://support.microsoft.com/en-us/...words-in-excel
https://www.extendoffice.com/documen...-to-words.html
hello john topley your solution is fine working, but one small change i want in that , this "RUPEES" word appearing in starting i dont want that word, so how can remove this word in VBA code please tell me.
Try this
Change this line
asPlease Login or Register to view this content.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thanks Mr. kvsrinivasamurthy
i want some change in that VBA code which you provided, i want that where is decimal value is equal or greater than 0.50 then round up that value to one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks