| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| character map | Excel Discussion (Misc queries) | |||
| Character Map | Charts and Charting in Excel | |||
| Date Formating and building character strings | Excel Discussion (Misc queries) | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
Threaded Mode
