=TEXT(SUBSTITUTE(TRIM(A1),".",""),"00!-00!-00")或=TEXT(LEFT(A1,4)&MID(5,2)&RIGHT(A1,2),"00!-00!-00") 复制得出的值,选中A1,右键----选择性粘贴----数值----再删去公式
=substitute（A1，".","- "） A1单元格内容为2012.04.01
