date to character
Hi everyone,
i have in a acolumn a series of dates:
09.15.2007
04.09.2008
12.24.2007
09.22.2007
06.05.2006
11.30.2006
i want to make them like:
september fifteenth 2007
etc..
for the month part i did text(a2,"mmmm") it gives me the month, for
the last mart i ll use year(a2)
ok but for the middle part like first, second, third, twenity
second ..... how will i be able to switch them? i tried of making a
table and use index-match combinations but it seems too much to me,
any ideas?
Thanks in advance
|