Is there any function in Excel that converts number into words.?
No, there isn’t any function in built. But there are many tools that provide such function without any hustle. For example the one mentioned above. Num2Text is also good. But, I prefer to do my own coding. Here’s an idea how you can do it with help of if, left and right function. 1. Separate each character in number. 2. Create a table containing word for each number, e.g. one, two, etc. 3. Create a table containing reference to Hundred, thousand, etc. (Tricky part is Eleven to ninety nine) 4. Convert Number to Word by using IF and than attach thousand, hundred etc. 5. There you have it.
