How to convert Date into text.
Solved/Closed
rk gupta
-
Jan 30, 2017 at 08:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 30, 2017 at 11:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 30, 2017 at 11:51 AM
Related:
- How to convert Date into text.
- Convert m3u to mp3 - Guide
- How to convert free fire id facebook to google - Guide
- How to convert number into words in ms word in shortcut key - Guide
- Convert picture to shape powerpoint - Guide
- Convert dts to ac3 mkvtoolnix - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 30, 2017 at 11:51 AM
Jan 30, 2017 at 11:51 AM
Hi rk gupta,
Use WordNum (google search the code) for the day and year (use DAY() and YEAR() to isolate those numbers). For the month use this:
=TEXT(A1,"mmmm")
Then string those 3 value together with & and maybe some " " for spacing.
Best regards,
Trowa
Use WordNum (google search the code) for the day and year (use DAY() and YEAR() to isolate those numbers). For the month use this:
=TEXT(A1,"mmmm")
Then string those 3 value together with & and maybe some " " for spacing.
Best regards,
Trowa
