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.