=text(a1,"aaaa")

=SUBSTITUTE(TEXT(A1,"00-00"),"-",": =TEXT(HOUR(A1),"00")&":"&TEXT(MINUTE(A1),"00")求解析整个公式各个部分的含义 =DATEDIF(TEXT(MID(A1,7,INT(LEN(A1)/2-1)),"#-00-00"),"2010-12 .aaaa ~~~~aaaa~~~~ =TEXT(ROW(A1)*2-1,H-164-")&TEXT((ROW(A2)-1)*2,"100") 这个公式中,如 比如：=TEXT((LEN(A1)=15)*19&MID(A1,7,6+(LEN(A1)=18)*2),"#-00-00 excel中的公式"=TEXT(DATE(LEFT(A1,4),MID(A1,6,2),RIGHT(A1,3)),"yy excel 如果A1包含aaaa,B1显示张三 exel 2010英文版公式=TEXT(WEEKDAY(A1),"dddd")无法返回英文值 A1=我是12他10,求B1公式（A1单纯数字求和＝4）,公式：{=SUM(--TEXT(MID(A1,ROW(1:50 TextBox1.Text = Mid(TextBox1.Text,1,Len(TextBox1.Text) -