[合集] 耐克官方对coolscan的回答很有意思# PhotoGear - 摄影器材
g*e
1 楼
请问如下的日期格式在excel里面是要怎样才能排序啊?
我试了excel的sorting功能,排完了貌似日期从远至近排好了,可是年号还是乱糟糟的
谢了
12/07/2011
08/31/2012
10/22/2012
10/31/2012
12/31/2012
07/01/2012
12/19/2012
12/31/2010
08/22/2011
09/24/2011
10/21/2011
11/22/2011
12/21/2011
12/21/2011
12/22/2011
01/17/2012
01/17/2012
01/21/2012
02/21/2012
02/22/2012
03/20/2012
03/21/2012
03/22/2012
04/21/2012
04/22/2012
我试了excel的sorting功能,排完了貌似日期从远至近排好了,可是年号还是乱糟糟的
谢了
12/07/2011
08/31/2012
10/22/2012
10/31/2012
12/31/2012
07/01/2012
12/19/2012
12/31/2010
08/22/2011
09/24/2011
10/21/2011
11/22/2011
12/21/2011
12/21/2011
12/22/2011
01/17/2012
01/17/2012
01/21/2012
02/21/2012
02/22/2012
03/20/2012
03/21/2012
03/22/2012
04/21/2012
04/22/2012