date of birth in words

[Naresh Maloo]

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.

 

[Andrew Poulsom]

Look here:

http://www.mrexcel.com/forum/excel-questions/615519-convert-date-words.html

 

[Rick Rothstein]

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 -->

Spell a Date out in Words