Convert a date figure into word in excel
Solved/Closed
Jaydeep
-
May 7, 2010 at 06:43 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 7, 2010 at 08:04 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 7, 2010 at 08:04 AM
Related:
- Convert a date figure into word in excel
- How to convert number to words in word - Guide
- Convert number to words in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- Convert m3u to mp3 - Guide
- Insert a tick in word - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 7, 2010 at 08:04 AM
May 7, 2010 at 08:04 AM
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"))
and then use this formula
=TEXT(A1, "MMMM") & " " & NBTEXT(TEXT(A1, "d")) & ", " & NBTEXT(TEXT(A1, "YYYY"))
