Tuesday, September 20, 2011

Convert Number to Words in Excel

I have been searching for an Excel function that can convert a number to words (i.e. 34 as Thirty Four). I found one which uses custom VB script. Since i need a solution that will work in every computer, i was forced to develop one. It was not easy. After many 'If's and 'Vlookup's later i was able to achieve my goal. My excel sheet actually converted a number to text. You can download the file by following the link given below. It still needs a lot of work and at this stage it wont convert multiple values. In the meantime, if anyone can point me to any easier method, i will be greatful. 

PS: Thanks Nithin for giving me the basic idea! :)


Download Excel File


Update 19-10-11: Version 2.6 released with minor bug fixes and improved data validation checks.

2 comments:

  1. Thx for the mentioning my name............
    Multiple value converter also you developed na...
    Lets see, if anyone comes up with any particular requirement, will incorporate that also....
    Time being it is great....
    If people want means they can incorporate this converter in their main menu of excel and use the same. That will be an easy way for end users......

    ReplyDelete