I have a list of date of birth in digits such as 05.06.1966 I want to write this in words as five june ninteen hundred sixty six. what will be the formula in excel for thic . please help me. thank you.
The following may work for you (depends on if the date format you use is recognized by Excel as a real date or not). The following UDF will output spelled out dates, but not in the exact format you requested; you example date would come back from my function as...
Fifth of June, One Thousand Nine Hundred Sixty-Six
If that output is okay for you, you can find the code it (and instructions on how to install the code) in my mini-blog article here...<!-- title / author block -->