S
scampbell
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. I’ve 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. I’m
assuming it’s tainted by Outlook somehow. Any suggestions? Thanks in
advance!
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. I’ve 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. I’m
assuming it’s tainted by Outlook somehow. Any suggestions? Thanks in
advance!