Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Number to words literal | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |