Previous Topic Next Topic

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

Answer 1 / 1
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Jun 13, 2016 at 10:30 AM
https://ccm.net/forum/affich-899537-convert-date-of-birth-into-words
JDK
Jun 14, 2016 at 01:44 AM
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

Similar discussions

Convert date of birth in word
kailash -
Ambucias -

1 response
convert date of birth into words
pandianjothi -
Ambucias -

1 response
How to convert date into words
shahid -
2massive-head -

2 responses
Date of birth in words
pinckroje -
TrowaD -

1 response
Date of birth number to words
Makk -
Jane -

2 responses