假设数据在A1问题1:b1=left(a1,8)c1=mid(a1,10,8)问题2:b1=text(text(left(a1,8),"0-00-00"),"e/mm/dd!-")&text(text(mid(a1,10,8),"0-00-00"),"e/mm/dd")
