A1:A4 为你原来的格式2-03-1 02-11-1 ， 2-2-3 。。。
B1公式下拉：
=TEXT(LEFT(SUBSTITUTE(A1,"-","*",1),FIND("*",SUBSTITUTE(A1,"-","*",1))-1),"00")&"-"&TEXT(MID(A1,FIND("*",SUBSTITUTE(A1,"-","*",1))+1,FIND("-",SUBSTITUTE(A1,"-","*",1))-FIND("*",SUBSTITUTE(A1,"-","*",1))-1),"00")&"-"&TEXT(RIGHT(SUBSTITUTE(A1,"-","*",1),LEN(A1)-FIND("-",SUBSTITUTE(A1,"-","*",1))),"00")
是时间格式吧, 假设数据在A列, 在B1输入下面公式, 然后下拉.
=TEXT(A1,"yy-mm-dd")
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024