如何设置excel中单元格内不同位数相乘调整成相同位数相乘的格式?_百度...答:B1单元格输入公式=TEXT(LEFT(A1,FIND("*",A1)-1),"0000")&"*"&TEXT(MID(A1,FIND("*",A1)+1,FIND("@",SUBSTITUTE(A1,"*","@",2))-1-FIND("*",A1)),"0000")&"*"&TEXT(MID(A1,FIND("@",SUBSTITUTE(A1,"*","@",2))+1,FIND("@",SUBSTITUTE(A1,"*","@",3))-1-...