Subject Location Topic StartDate
Burleson 1 A/P - Str Blwrs11/15/05
Burleson 2 Electromag Exper11/29/05
Burleson 4 Crystals 01/13/06
Burleson 5 Fossils 01/20/06
Burleson 6 Pond/SU Aquarium01/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!
- Aug 28 Tue 2007 20:38
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl
close
全站熱搜
留言列表
發表留言