This is a formula from John Walkenbach's "Microsoft Excel 2000 Formulas"
book.

=DAY(A1)&IF(INT(MOD(DAY(A1),100)/10)=1, "th", IF(MOD(DAY(A1),10)=1,
"st",IF(MOD(DAY(A1),10)=2,"nd", IF(MOD(DAY(A1),10)=3, "rd","th"))))& " "
&TEXT(A1,"mmmm, yyyy")



--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
Perhaps this will give you an idea of how to do. Create a lookup table for
the days. If the year will be different do the same.

="The " &VLOOKUP(C19,G18:H22,2)&" day of "&TEXT(C17,"mmmm")& " Two
thousand
five"

--
Don Guillett
SalesAid Software

"Frustrated" wrote in message
...
I need some help changing a date such as 11-Aug-05 to "the eleventh day
of
August, two thousand five. I used the file in Excel 2000 that made the
conversion but it is not working with my Excel 2003. Any suggestions?
Thanks for your help.
--
Frustrated