Convert date of birth in word

kailash - Jun 10, 2017 at 01:44 AM - Latest reply: Ambucias 51833 Posts Monday February 1, 2010Registration dateModeratorStatus May 25, 2018 Last seen
- Jun 10, 2017 at 05:06 PM
Hello,

pls tell me formula for convert date of birth in word in excel
See more 

Your reply

1 reply

Best answer
Ambucias 51833 Posts Monday February 1, 2010Registration dateModeratorStatus May 25, 2018 Last seen - Jun 10, 2017 at 05:06 PM
5
Thank you
Download addon MOREFUNC from http://download.cnet.com/Morefunc/3000-2077_4-10423159.html

and then use this formula
=TEXT(A1, "MMMM") & " " & NBTEXT(TEXT(A1, "d")) & ", " & NBTEXT(TEXT(A1, "YYYY"))

Thank you Ambucias 5

has helped 17822 users this month

Respond to Ambucias