How to convert Date of Birth to word in Excel

Closed
kjustind Posts 1 Registration date Monday June 13, 2016 Status Member Last seen June 13, 2016 - Jun 13, 2016 at 03:09 AM
 JDK - Jun 14, 2016 at 01:44 AM
Dear sir,

I have placed my date of birth 25/04/1977 in one cell in excel and I need the result as "Twenty fifth April Nineteen Seventy Seven "as in another cell.

Kindly give me the codings for the same.

Thanks & regards,

Justin Davis

1 response

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Jun 13, 2016 at 10:30 AM
0
25/04/1977 it should be converted as "Twenty fifth April Nineteen Seventy Seven " and Not like "Twenty fifth April One thousand Nine Hundred and Seventy Seven ".

Thanks in advance
0