Labels

Wednesday, 27 July 2011

Amount in words

Amount in words
Microsoft excel, does not by default, offers a function to convert a numerical value into text. However, it allows you to do so using its visual basic editor.
Open the excel workbook in which you intend to use the functionality. Press   Alt+F11  to open the Visual Basic Editor. Click  Insert  >  Module  (a new window will open). Copy and paste the code. Save and close the visual basic editor and then save the excel workbook in Excel macro-enabled format.
Now open the excel workbook and use the function as    =spellnumber(Cell reference)   
 If you are familiar with VB code, you can modify the code according to your own needs. For example, if your local currency is other than dollar i.e “Rupees” with sub unit “Paisas” you can find and replace “Dollars” and “Cents” with your relevant currency units.
Remember that this would work only in the excel workbook in which you have inserted the module.

 To download the VB code referred to in this post and the template files, please visit: https://sites.google.com/site/officetemplatesource/news/untitledpost

No comments:

Post a Comment