close

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!

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()