Numbers to Words

UDF to Convert Numbers to Letters

First of all, wouldn't it be great if we have a built in function in Microsoft Excel to Convert Numbers to Letters. It means, simply, by using a formula in excel, I could Spell Numbers in Words. In banking or accountancy, this is used to write grand total amounts. Amounts are mentioned in Numbers as well as words. You probably [...]

User Defined Function in Excel to Convert Currency to Words

Many a times we require to change the Numbers in Words. For Example: 6734862=Sixty Seven Lakhs Thirty Four Thousand Eight Hundred Sixty Two. In Excel, there is no Formula as such to Convert Numbers in Words. I have written one UDF : User Defined Function. After using this Function, you will be able to change any numbers in Words. Now [...]