Date to Words

F

Frustrated

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.
 
D

Dave O

Rather than recreate the wheel, I suggest recreating the conditions
under which the XL2k file worked. It may have something to do with
add-ins: with the Excel 2000 file open, click >Tools >Add-Ins, and
select the same features that were selected in Excel 2000. This may
require a bit of trial and error or informed guesses, but should be
quicker than figuring out the whole deal again.
 
D

Don Guillett

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"
 
D

Don Guillett

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")
 
Top