Report

How to convert Date into text. [Solved]

Ask a question rk gupta - Last answered on Jan 30, 2017 at 11:51 AM by TrowaD
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 
Helpful
+0
plus moins
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
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!