Convert date of birth in word [Solved/Closed]

Report
-
Ambucias
Posts
51400
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
March 18, 2020
-
Hello,

pls tell me formula for convert date of birth in word in excel
Related:

1 reply

Posts
51400
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
March 18, 2020
14,437
Download addon MOREFUNC from https://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"))
6
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3798 users have said thank you to us this month