| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
routine to convert to date format
I have a worksheet that contains dates.
The dates have been entered in general format. For the month of November (2004) they are, (for example) Sun 7, Mon 8, Tues 9, Wed 10, Thurs 11, Fri 12, Sat 13. I would like to convert these text entries to the appropriate date number. So Sun 7 would become 38298, formatted as ddd d. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
| Convert european foreign date format to US date format | Excel Worksheet Functions | |||
| convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
Threaded Mode
