How to Convert Numbers in to Words(In Indian Rupees)
Hello Friends, I am again comeback with an interesting PC tricks for you.I hope you will learn new things.Here now How to Convert Numbers in to Words(In Indian Rupess). Following function convert ( Rupees in figure ) numeric value in a Microsoft Excel worksheet cell into its equivalent in (Rupees in Word ) English words. e.g.it is the formula.. =SpellNumber(45 )will display as Rupees forty five rupees only. Follow instructions care fully>>> How to create the sample function Called SpellNumber Start Microsoft Excel. Press ALT+F11 to start the Visual Basic Editor. On the Insert menu, click Module . Type the following code into the module sheet. After copying following code, Enable macro and use above function. How to Convert Numbers in to Words(In Indian Rupees)Add caption Function SpellNumber(amt As Variant) As Variant D...
really intersting nice post
ReplyDelete