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

rk gupta - Jan 30, 2017 at 08:49 AM - Latest reply: TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen
- Jan 30, 2017 at 11:51 AM
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


See more 

1 reply

TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen - Jan 30, 2017 at 11:51 AM
0
Helpful
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