excel中怎么將13-1-1,13-2-1,13-3-1,13-10-1,13-11-1,13-12-1進行排序呢?
希望13-10-1,13-11-1等排在13-2-1的后面.
eg：現(xiàn)在有13-1-1,13-1-2,13-2-1,13-2-2,······直到13-10-1,13-10-2,13-11-1,13-11-2.將其進行排序,優(yōu)先第一位數(shù)字,然后按照中間這個數(shù)字,最后按照末尾數(shù)字來排序.
若是13-1-1-1,13-1-1-2.,13-1-2-1,13-1-2-2······到13-1-10-1,13-1-10-2,13-1-11-1,13-1-11-2···又怎么排啊?