How to convert Date into text. [Solved]

Ask a question rk gupta - Last answered on Jan 30, 2017 at 11:51 AM by TrowaD
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

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:

Then string those 3 value together with & and maybe some " " for spacing.

Best regards,
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!