| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
text date to date format
I have column filled with:
'Apr 3 2005 4:37PM And I need to change it to: 04/03/05 4:37PM How do I get a textual date column into a sortable date/time column? I'm having problems because it sorts everything by alpha then numeric. For example, I have "Apr 15, 2005" before "Aug 10, 2003". I need to get these sorted by year, month, day...not alphabetically. Thanks in advance for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
| Help - Date Format | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
