| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl
Subject Location Topic StartDate
Burleson 1 A/P - Str Blwrs 11/15/05 Burleson 2 Electromag Exper 11/29/05 Burleson 4 Crystals 01/13/06 Burleson 5 Fossils 01/20/06 Burleson 6 Pond/SU Aquarium 01/27/06 Burleson 3 Mxt/Solns 12/13/05 Cabell Elem 02/03/06 Hello all. I need to sort this info that I exported (as an Excel file) from Outlook calendar (text view). I would like to sort first by €śsubject€ť (alphabetically) and second by €śStartDate€ť (in ascending date order). All is well until we get to €ś12/13/05€ť (see above). The New Math they taught me states that Dec. 13, 2005 comes before Jan. 13, 2006. Ive tried €śhelper€ť columns (where I pasted as €śvalue€ť, then successfully formatted as mm/dd/yy), going to serial view, text-to-columns, emailing it my sister, unlocking protection and sleeping all night in my chair with the mouse in hand. Im assuming its tainted by Outlook somehow. Any suggestions? Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Can I embed my Outlook Calendar into an Excel Spreadsheet? | Excel Discussion (Misc queries) | |||
| Am I able to sort dates by month rather than year in excel? | Excel Discussion (Misc queries) | |||
| Is it possible to add dates in an excel worksheet to Outlook Cale. | Excel Discussion (Misc queries) | |||
| Excel 2002 vs Outlook 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
