Date to Words
 

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

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.

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

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