| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I sort dates stored as 1-Jun-05 in order of day & month
I have a column that has dates entered as 1-Jun-5 so numbers and text and I
cant seem to get it to sort by month and day. When I try to change all the dates to numbers only it wont change them all. HELP |
|
#2
|
|||
|
|||
|
Try this ..
Select the col with the dates Click Data Text to Columns Click Next Next In step 3 of the wizard: Under Column data format, Check "Date" (ensure "DMY" is selected in the droplist) Click Finish -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "stuckiniraq" wrote in message ... I have a column that has dates entered as 1-Jun-5 so numbers and text and I cant seem to get it to sort by month and day. When I try to change all the dates to numbers only it wont change them all. HELP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I sort multiple months/years WITHOUT Alpha order taking o. | Excel Worksheet Functions | |||
| I have two identical pivot tables with different sort order of th. | Excel Discussion (Misc queries) | |||
| How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) | |||
Linear Mode
