How to convert Date into text. [Solved/Closed]

Report
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
Hello,
how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two


1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!