在b1输入 =TEXT(DATE(MID(A1,7,4),MID(A1,11,2),MID(A1,13,2)),"yyyy年mm月dd日") 在c1输入 =IF(MOD(MID(A1,17,1),2)=0,"女","男")
2012-05-07 06:06
2012-04-19 20:59
2012-03-15 20:27
2012-01-22 08:49
2011-09-19 08:43
2011-09-19 08:42
2011-09-15 16:14
2011-06-09 12:42
2011-02-02 13:17
2011-01-12 07:56
|






