Convert a date figure into word in excel [Solved/Closed]

- - Latest reply: rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- May 7, 2010 at 08:04 AM
I want to know the formula, how can I convert a date figure into word in excel 2003
See more 

1 reply

Best answer
approved by Jean-François Pillou on Nov 29, 2018
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
917
2
Thank you
Download addon MOREFUNC from http://download.cnet.com/Morefunc/3000-2077_4-10423159.html

and then use this formula
=TEXT(A1, "MMMM") & " " & NBTEXT(TEXT(A1, "d")) & ", " & NBTEXT(TEXT(A1, "YYYY"))

Say "Thank you" 2

A few words of thanks would be greatly appreciated. Add comment

CCM 3274 users have said thank you to us this month