![]() Keep the cursor in the box where you want to convert numbers into Words in Excel Sheet and type Open the requires Excel Sheet and Press Alt+F11Ī new Windows will appear just click insert and then moduleĬlick on File and then Close and Return to Microsoft Excel ![]() SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 1))) + " Hundred " ![]() If i = 1 And Val(Left(FIGURE, 2)) > 0 ThenĮlseIf i = 2 And Val(Left(FIGURE, 2)) > 0 ThenĮlseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1))) ![]() SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1))) SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2))) It is very easy to convert numbers into words in Indian or Pakistan Rupees by using spellnumber function, just follow the steps given below.Ĭopy the given code carefully or you can GET CODE FROM THIS LINK Function SpellNumber(amt As Variant) As Variant How to use SpellNumber Function to Convert Numbers into words in Excel in Indian and Pakistani Rupees: Learn to Calculate Range in Excel by using Excel Range Function.How to add a drop-down list to a cell in Excel.This trick will work for most of the Microsoft Excel versions (2003,2010,2013) But need not to worry because I have compiled this article for such people who want to use this Excel function. Let’s say we have a daily routine to manage some calculation and we have to manually input these results from numbers into words especially in Indian or Pakistan Rupees, then it must be annoying or boring to do the same practice and alternatively loss of valuable time. Especially the ones who are linked with accounts and they often faced the situation where they have to convert numbers into words for the ease of their account holder and for other persons. Most of the computer users know about Microsoft Excel and its importance in office work. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |